Goldengate : Direct Load - Initial Load Techniques
(Doc ID 1457164.1)
Last updated on DECEMBER 02, 2019
Applies to:Oracle GoldenGate - Version 10.0.0.0 to 188.8.131.52.3 [Release 10.0.0 to 11.2]
Information in this document applies to any platform.
Checked for relevance on 30-May-2014
GoldenGate Initial Load: Loading Data with an Oracle GoldenGate Direct Load.
The document discusses the method of performing an initial-load with an Oracle GoldenGate Direct Load, the necessary parameters to be configured for the GoldenGate processes, and it provides reference to tutorials/examples and additonal caveats and known issues.
This document should be read in conjunction with Document 1311707.1 Master 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 on all initial load methods.
The note is intended for new implementations of GoldenGate where the source data needs to be instantiated on the target database in order to replicate the data using GoldenGate.
With initial-loads using GoldenGate Direct Load, the Extract process communicates directly across TCP/IP without the need to use a collector process or any files.
Direct Load method is process to process, hence it does not use an intermediate trail.
The Replicat process applies the data through the database engine.
This is the standard method of Initial Load. It is very flexible and a very fast way to do an initial load once it has been configured adequately and tested.
GoldenGate Direct-Load method allows additional data transformations and mappings which can be done by Extract or Replicat or both.
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.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document
|Performing an Initial Data-Load Using GoldenGate Direct-Load|
|Tutorials - Loading Data with Oracle Direct-Load|
|Additonal Notes and Known Issues|
|DataType and Object Restrictions|
|Other Known Issues|