Goldengate : File To Database Utility - Initial Load Techniques (Doc ID 1457989.1)

Last updated on AUGUST 26, 2021

Applies to:

Oracle GoldenGate - Version 10.0.0.0 to 11.2.1.0.3 [Release 10.0.0 to 11.2]
Information in this document applies to any platform.

Purpose

GoldenGate Initial Load: Loading Data from File To Database Utility

The note discusses how to configure the necessary initial-load processes and parameters, and it provides an example that illustrates the technique.

This document should be read in conjunction with the Note: 1311707.1 Primary Note for Oracle GoldenGate: Initial Load Techniques

Also, refer to the Oracle© GoldenGate Windows and UNIX Administrator’s Guide, chapter titled Running an initial data load, for detailed information about all initial load methods.

Scope

The document discusses the method of performing an initial-load using a database bulk-load load utility by using an initial-load Extract to extract the data from the source tables and write them to an external file in ASCII format. The file then can be read by a database utility, specifically:

Oracle's SQL*Loader
Microsoft's BCP / DTS/ or SQL Server Integration Services (SSIS) utility
IBM's Load Utility (LOADUTIL)

During the initial load, the change synchronization Extract/Replicat groups perform the extraction and apply of incremental changes that are then reconciled with the results of the load.