How To Deal With Deletes Tracked By ODI Changed Data Capture?

(Doc ID 730252.1)

Last updated on MAY 18, 2018

Applies to:

Oracle Data Integrator - Version: 10.1.3.4.0 and later   [Release: 10gR3 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

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 hundreds of Community platforms