My Oracle Support Banner

How To Synchronize Deletes of Source Rows to a Target Table without Truncate and Delete All (Doc ID 2744799.1)

Last updated on FEBRUARY 03, 2021

Applies to:

Oracle Data Integrator - Version 12.2.1.4.0 to 12.2.1.4.0 [Release 12c]
Information in this document applies to any platform.

Goal

An Oracle Data Integrator (ODI) mapping keeps a target table synchronized with new data on the source. However, when a row is removed from the source, the row remains on the target.

How can the target remain synchronized with the source without truncating the target and performing a full load? 

For example:

  1. A mapping is executed to synchronize the SOURCE_TABLE data to the TARGET_TABLE table.
  2. One or more records in the SOURCE_TABLE table are deleted. The corresponding TARGET_TABLE standard physical IKM does is not set to delete or truncated.
  3. The mapping is executed again. The deleted records on the SOURCE_TABLE still exist in the TARGET_TABLE table.

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!


In this Document
Goal
Solution


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