My Oracle Support Banner

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

Last updated on MARCH 31, 2023

Applies to:

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

Goal

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.

Solution

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

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


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