Writing Deleted records to separate tables or adding an audit column in target table

User_RNDR7

Hi,

What is the best practice to capture deleted records when replicating using GoldenGate.

• Using an audit column in the target and using INSERTDELETES with sysdate/default value for the audit column

INSERTDELETES
MAP sogg.sample_data_1, TARGET stgg.sample_data_1, &
COLMAP (USEDEFAULTS, DATE_DELETED = @DATENOW())

• Inserting deleted records to a separate table and using ALLOWDUPTARGETMAP parameter

IGNOREINSERTS
IGNOREUPDATES
INSERTDELETES
MAP sogg.sample_data_1, TARGET stgg.sample_data_1_deleted

Thanks !

Veera-Oracle

Hello,

Having an Audit table will be a better approach. for example,

MAP sogg.sample_data_1, TARGET stgg.sample_data_1;
MAP sogg.sample_data_1, TARGET stgg.sample_data_1_audit INSERTALLRECORDS;

In this way, you can maintain the history of transactions. Also, you can add additional columns like operation type, operation timestamp etc, to the audit table.

Please check the below link,

https://www.oracle-scn.com/insertallrecords-to-maintain-a-transaction-history/

Regards,

Veera