OraFAQ Forum: Replication » Is it possible to parallelise Initial Load in Golden Gate?

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)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Is it possible to parallelise Initial Load in Golden Gate? [message #619238]

Sun, 20 July 2014 16:34

chetankumar
Messages: 20
Registered: June 2014
Location: Dark Saturn

Junior Member

Hello

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
Chetankumar

Report message to a moderator

Previous Topic:	Remove Archivelog from Staging Server
Next Topic:	Character Set Issue

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Feb 06 16:35:41 CST 2025