My Oracle Support Banner

How To Deal With Deletes Tracked By ODI Changed Data Capture? (Doc ID 730252.1)

Last updated on OCTOBER 31, 2019

Applies to:

Oracle Data Integrator - Version and later
Information in this document applies to any platform.


You have ODI CDC started on some source tables and among the changes tracked, there are also Deletes. You may wonder what options are available in ODI for such journal changes.

The IKM Oracle Incremental Update Synchronize deletions from journal step deletes the records on the target table that were tacked as a Delete on the source table journals.This Note shows how to enable such journal changes tracked as Deletes getting deleted and how to perform a soft delete instead of a physical delete.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
 How to make sure Deletes tracked by CDC are deleted:
 How To Perform Soft Deletes on journal changes tracked as Deletes?

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.