How to Flag when deleting is being performed by GoldenGate on target table
edited Nov 19, 2014 10:37PM in GoldenGate, Streams and Distributed Database (MOSC) 5 commentsAnswered
Hi,
I am asked to replicate certain tables in real time from 10g database to 11g database by using GoldenGate with the following requirement. I do not see any issues with the insert and updates, but not sure as how to flag the delete operation , since the record itself will be deleted. Do you have any suggestions on it?
Your early response is very much appreciated.
=============================
To replicate:
1) Inserts: there should be a new record in target --- When inserted by GG, it should update the column -GG_OPERATION with the Flag - I
2) Updates: the record existing in target MUST be updated -- When inserted by GG, it should update the column -GG_OPERATION with the Flag - U
0