GoldenGate, Streams and Distributed Database (MOSC)

MOSC Banner

CDR

edited Mar 21, 2014 12:00PM in GoldenGate, Streams and Distributed Database (MOSC) 4 commentsAnswered

How can I achieve the following with CDR in goldengate Active-Active configuration.

Table 1

----------

Column1  -- PK

Column2

Column3

Column4 -- UpdateTime

If user at Site A updates Column2  and user at site B updates Column3 corresponding to the same PK at nearly the same time (i.e before one gets replicated to the other).

In this case, I need both the sites to be updated with both the updated column values.

But with the same configuration I should also be able to resolve a situation where two users at different sites update the same column corresponding to the same PK. In this case however, I need it to be resolved using the latest update time i.e Column4.

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