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 MARCH 08, 2023

Applies to:

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


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.


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.