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 3.2.03.01 and later
Oracle Data Integrator on Marketplace - Version 1.0.2 and later
Information in this document applies to any platform.

Purpose

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.

Scope

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?