need to replicate table based on a column flag and stop after first instance of replication after th
edited Apr 10, 2013 9:26AM in GoldenGate, Streams and Distributed Database (MOSC) 3 commentsAnswered
We are required to implement goldengate replication for logic described below.
We need to start replicating from our tracking tables for all changes happening (insert,update,delete) until the common column "DATA_STAT_CDE" flaged with any value (R,E,S) other than null. (with the exception that the very first time the column become not bull, we need to replicate and stop replicating further changes.)
For EG
first insert
Insert > col1 = a col2=b DATA_STAT_CDE=null >> replicate
subseqent changes to the table other than making DATA_STAT_CDE not null.
update > col1 = c col2=d DATA_STAT_CDE=null >> replicate
0