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:

File to Replicat method

We will be using the File to Replicat method to perform our Initial Load, starting with the Initial Data Capture configuration.

Configuring Initial Data Capture

The first step is to create the Initial Data Capture Extract parameter file for EMP and DEPT tables that exist in the SRC schema of the OLTP source database. The SRC schema is based on the Oracle...