My Oracle Support Banner

How To Configure ODI Mapping to Truncate and Load Latest Data Instead of Appending to Existing Set of Records when Using File as Target Data Store (Doc ID 2948679.1)

Last updated on MAY 19, 2023

Applies to:

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

Goal

While loading data from source table to target file data store using Oracle Data Integrator (ODI) Mapping, by default the records are appended to the target file. How to replace the existing data and load only the latest set of records?

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.