Skip to Main Content

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Oracle Data Integrator(ODI) Error Handling

User_9AGUDJun 11 2021 — edited Jun 12 2021

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!

Comments