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 !