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 220.127.116.11.0 and later
Oracle Data Integrator on Marketplace - Version 18.104.22.168.200123 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?
- A mapping is executed to synchronize the SOURCE_TABLE data to the TARGET_TABLE table.
- 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.
- 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!