This chapter has provided an overview of the advanced configuration options that GoldenGate has to offer. We started with data selection using the
FILTER clauses before moving onto data mapping, exploring the
COLMAP option and the
DEFGEN utility. Finally, we discussed data transformation and the vast array of functions and tools available.
We also discovered that should GoldenGate not provide a function or mapping specific to our requirements, we can write our own in PL/SQL, C or C++. The GoldenGate software provides the necessary call interface to stored procedures and external routines.
In the next chapter, we learn how to measure and report on your GoldenGate performance. Here, we will discover the on demand and automated procedures ...