Home » Server Options » Replication » Is it possible to parallelise Initial Load in Golden Gate? (SQL Server 2008 on windows2008 server, Oracle 11g R2 on linux)
Is it possible to parallelise Initial Load in Golden Gate? [message #619238] Sun, 20 July 2014 16:34
Messages: 20
Registered: June 2014
Location: Dark Saturn
Junior Member

Is it possible to Parallelise Initial Load process in Golden Gate?

We are trying to replicate data from SQL Server 2008 to Oracle 11g R2 and want to optimize the process

I understand the 'Change Synchronization' can be optimized by using multiple extracts, RANGE function, SQLPREDICATE parameter but not while Initial Load as it does not use Checkpoint (sourceistable) also the in 'Trail to Replicat' maxfiles can write to multiple files but that won't be parallelism as replicat will load sequentially only

We have few LOB objects so we are not selecting 'direct load' options however if we get some mechanism we would go for it
even with 'Direct load' method taking care of LOB in later stage

Please suggest any mechanism to speed up the initial load in replication of heterogeneous databases

Thank you

Kind Regards

Previous Topic: Is it possible to use pump process during initial load in Golden Gate?
Next Topic: Character Set Issue
Goto Forum:

Current Time: Tue Nov 21 23:35:30 CST 2017

Total time taken to generate the page: 0.02181 seconds