Chapter 7. Advanced Configuration
In this chapter, you will gain a deeper understanding of GoldenGate configuration. The topics covered in this chapter include data selection, mapping, and transformation. One could argue that this sounds remarkably like Extract, Transform and Load (ETL) in concept. One would be right. However, combining GoldenGate's real-time Change Data Capture (CDC) with an ETL tool, known as Extract, Load and Transform (ELT), decreases data latency and eliminates the need for batch processing. This poses two questions:
How much data transformation should GoldenGate do?
Should the Replicat process load the production tables directly?
The answers to the above questions would decide whether or not an ETL tool is required, thus illustrating the power of GoldenGate's advanced configuration.
This chapter discusses the following in detail:
Data mapping at column level to deal with different source and target table structures
Data selection and filtering using a WHERE clause or FILTER...
