GoldenGate, Streams and Distributed Database (MOSC)

MOSC Banner

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 

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center