CODEWITHSUNDEEP
etloracle-data-integratororacle-warehouse-builder
Nikitha
Nikitha

Reputation: 35

Oracle Data Integrator(ODI) Error Handling

Is there any error handling mechanism in ODI. I am trying to handle a scenario where ODI can load the bad data into error table when it fails to do transform source data and insert into target table.So that process will not get stopped even if there is any change in the incoming data format.

Upvotes: 1

Views: 5520

Answers (1)

JeromeFr
JeromeFr

Reputation: 1928

Most of the Integration Knowledge Modules (IKMs) have an option to enable or disable Flow Control. When Flow Control is enabled, these main steps will occur :

  • The data will first be inserted into a temporary table which has the same structure as the target table. These tables are prefixed by I$_ by default
  • All the conditions (constraints) defined in the model for the target datastore will be checked.
  • The rows failing the conditions will be inserted in an error table with some information about the loading time, the condition which has been broken and all the data of the row. These tables are prefixed by E$_.
  • The rows passing the conditions will be inserted/updated in the target table.

Needless to say, enabling Flow Control will affect the performance of your loading as there is an extra insert and some conditions checks. But if catching data quality issues is needed, it's a great feature which is easy to implement.

Upvotes: 1

Related Questions