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

Performing the Initial Load

Let's now step through the necessary tasks required to perform an Initial Load using the File to Replicat method. For small and simple data synchronization with no transformations, this is the preferred solution.

Example architecture

This example assumes the target tables are truncated and are identical in structure to the source tables. The configuration includes the following methods:

Initial Load: File to Replicat data synchronization

One-to-One: Change Data Capture and Delivery

The system schematic diagram below illustrates the architecture and naming convention used in this chapter's examples:

Example architecture

File to Replicat method ...

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