CDR
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.