Summary
This chapter has provided an overview of the advanced configuration options that GoldenGate has to offer. We started with data selection using the WHERE
and 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 for statistics gathering and process monitoring, enabling effective system management.