Handling collisions Bi-directional, updte on qty column not working
edited Apr 2, 2013 5:04PM in GoldenGate, Streams and Distributed Database (MOSC) 7 commentsAnswered ✓
I am attempting to simulate a Bi-directional Golden Gate update to a table and the row is not getting updated but instead is getting added.
Supplemental logging is on for all columns I have added a Primary Key, used KEYCOLS, same problem, no Update performed.
I am attempting to simulate Bi-directional Quantitative Conflict resolution from a source to a target cascading topology.
Table data in source.
There are no Indexes or Primary key on the source or target tables, but they are identical.
OGG_TEST.INVALID_ATTEMPT_TB table one row
RQUID 123
ACCOUNT_NUMBER 6
DELETE_INDICATOR 2
ADD_DATE 10/16/2012 6:06:14 PM
UPDATE_DATE 3/29/2013 10:36:03 AM
Supplemental logging is on for all columns I have added a Primary Key, used KEYCOLS, same problem, no Update performed.
I am attempting to simulate Bi-directional Quantitative Conflict resolution from a source to a target cascading topology.
Table data in source.
There are no Indexes or Primary key on the source or target tables, but they are identical.
OGG_TEST.INVALID_ATTEMPT_TB table one row
RQUID 123
ACCOUNT_NUMBER 6
DELETE_INDICATOR 2
ADD_DATE 10/16/2012 6:06:14 PM
UPDATE_DATE 3/29/2013 10:36:03 AM
0