Tables to be replicated in Sequence
edited Nov 19, 2013 7:33AM in GoldenGate, Streams and Distributed Database (MOSC) 3 commentsAnswered
Hi All,
I have requirement to replicate the tables in a specific order since the data in the tables as dependencies, I would like to check whether goldengate replicates the tables as per the sequence in the extract and replicat or is there any specific parameter, which can be added in EXTRACT/REPLICAT to replicate the tables in sequence.
Also can you please let me know, whether if the tables existing in the same schema as parent-child relationship, will replication maintains those reference between the two tables ?
Thanks in Advance.
Sridhar Dilli
I have requirement to replicate the tables in a specific order since the data in the tables as dependencies, I would like to check whether goldengate replicates the tables as per the sequence in the extract and replicat or is there any specific parameter, which can be added in EXTRACT/REPLICAT to replicate the tables in sequence.
Also can you please let me know, whether if the tables existing in the same schema as parent-child relationship, will replication maintains those reference between the two tables ?
Thanks in Advance.
Sridhar Dilli
0