Performing the initial load

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

The example architecture

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

  • The Initial load: This specifies the Direct Load data synchronization
  • The one-way replication: Change data capture and delivery

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

Direct Load instantiation

We will use the Direct Load instantiation method ...

Get Oracle GoldenGate 12c Implementer's Guide now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.