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!

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

LakshmideepakJun 27 2022 — edited Jun 27 2022

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 !

Comments
Post Details
Added on Jun 27 2022
1 comment
164 views