Oracle Data Integrator(ODI) Error Handling

User_9AGUD

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.

Example: Source table exists 10 rows which are 8 rows good and 2 rows bad. How to config in ODI that can handle this case without fail ODI job during running this job.

Appreciate your help! Thanks!

Christian.Shay -Oracle

I moved this to the ODI forum....

User_9AGUD

Someone has comment on this. Thanks

Marco Fris

Depends on your definition of 'good' data.

If you can express your criteria in terms of database constraints (uniqueness, referential constraints, check constraints) then ODI's CKMs can help. A CKM verifies incoming data against those constraints and puts records that violate any into an error table. Basic but effective.

They appear to have been omitted in recent documentation, but to my knowledge this older guide is still valid.

Have fun, Marco

User_9AGUD

Thanks Marco. How to implement The rows failing the conditions will be inserted in an error table which are prefixed by E$_? Which IKM can I use? Does IKM exist or not?

Thanks a lot

Loan

Marco Fris

Hi Loan,

It is the CKM that does that. You can select it in the same way you pick you IKM: on the physical tab of your mapping with the target selected.

Did you spot the link to the tutorial? https://docs.oracle.com/cd/E21043_01/integrate.1111/e12641/quality.htm

Have fun, Marco

et4891

Hello Loan,

If you aren't able to find any IKM which I had a hard time finding it so made a post https://community.oracle.com/tech/apps-infra/discussion/4484961/import-create-integration-knowledge-modules

Look at the answer accepted, thanks to @Marco Fris for helping me out finding where to import

ET