GoldenGate, Streams and Distributed Database (MOSC)

MOSC Banner

comparing additional columns

edited May 13, 2014 12:00PM in GoldenGate, Streams and Distributed Database (MOSC) 2 commentsAnswered

Hello,

We do not want any CDR. But we want additional protection by comparing an additional column during replication. So we want replicat to compare the key columns and additionally one other column. However that comparison is not an equality comparison i.e. it is not source col = target col. Instead it is source col >= target col. I guess COMPARECOLS with Keysincluding is the only way but how do we check for >= ?

Secondly, is there a way to instruct GG to compare the After image from the source with the target value? It seems to be comparing the Before image always.

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