O'Reilly logo

Oracle GoldenGate 11g Implementer's guide by John P Jeffries

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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:

  1. How much data transformation should GoldenGate do?
  2. 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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required