My Oracle Support Banner

How To Set Up Procedures To Detect Erroneous Source Data In ODI Integration Interfaces (Doc ID 1637947.1)

Last updated on JUNE 16, 2022

Applies to:

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

Goal

When processing several tens of millions of records in ODI Integration Integration it is possible that a very small number of records contain fields in which an incorrect value is present.

For example, columns of DATE type may contain incorrect data and / or format, which, at runtime, generate error messages and provoke a rollback of the entire dataset. As such, it would be interesting to determine which precise records fail in order to minimize rollbacks and increase the feasibility of identifying erroneous data. Is it possible to set up such processing with ODI ?

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!


In this Document
Goal
Solution
References


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