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!