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.
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: