Skip to Main Content

GoldenGate

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Data mismatch Oracle Golden Gate Big data 21.4 replication to snowflake from informix

User_1V7NKApr 22 2022

Please we are using oracle golden gate big data 21.4 from informix (Extract) and replicating directly into snowflake (Delivery) using snowflake internal stage, but we continuously have data in the source more than target and in the target more than in the source. we have tried everything possible using keycols to specify unique columns , later changed it and used keycols for all columns. used parameter INSERTUPDATES, INSERTMISSINGUPDATES e.t.c, but we continously have target in source than target and target than source, Please who can help...any advice.
(Source does not have primary keys and unique keys)

Comments
Post Details
Added on Apr 22 2022
1 comment
376 views