My Oracle Support Banner

Static and Dynamic Data Control Modes Implemented by Oracle Data Integrator (Doc ID 789018.1)

Last updated on OCTOBER 11, 2023

Applies to:

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


The purpose of this document is to describe the different modes of control implemented by Oracle Data Integrator (ODI) to check data according to the constraints defined on Datastores and/or 12c Mappings and 11g/10g Integration Interfaces.

This document is not related to 10g Oracle Data Profiling (ODP) and Oracle Data Quality (ODQ). For information about these products, refer to:

Document 787280.1 - Where Can I find More Information about Oracle Data Quality (ODQ) And Oracle Data Profiling (ODP)

The article applies to all releases of ODI like the current 12C as well as to previous releases.


Is there a way to verify the integrity of Oracle Data Integrator (ODI) Datastore data by identifying invalid (error) records?

Is there a way to verify the data flow before inserting data into the target 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!

In this Document
 Oracle Data Integrator Static Control
 Oracle Data Integrator Flow Control
 ODI documentation
 Why is there a differentiation between the records created by Flow Control and Static Control in the E$ error table?
 Why are error records differentiated when they are created by different Mappings / Interfaces that populate the same target Datastore?
 How is it possible to recycle the error records which are present in the E$_ table and to ensure that they are integrated into the target table?
 Is it possible to recycle all invalid records (errors) without modifying the IKM?
 What are the reasons for a record to be identified as invalid (erroneous) in a Flow Control?
 How can invalid records be moved into the E$ error table when a Mapping / Interface uses Static Control to check the accuracy of target Datastore?
 How can standard KMs be used to load data into Datastores with self-referencing Foreign Keys?

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