Forum Stats

  • 3,734,428 Users
  • 2,246,970 Discussions


Oracle Data Integrator(ODI) Error Handling

User_9AGUD Member Posts: 3 Red Ribbon
edited Jun 12, 2021 1:45AM in Data Integrator

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!


Sign In or Register to comment.