Dear Experts,
I am quiet new to ODI. customer requesting our strategy to deal with erraneous records or failure job.
I would like to know to design effective strategy to deal with error records.
How generally we need to clean error records ? is there any good weblink or document which i can follow to deal with data left in E$ table.
do we need to do manually modify the data errors ? How to re-run records failed with pk voilation or business rule violation.
how to re-run failed interface in the middle after processing 80 % of records ?
if we have huge number of records left in E$ table, do we need to correct each and every record ?
How many types of error you may get while doing the execution ?. All these questions raised by customer..
any good websource or link where i can get information for above questionnaire...
Thanks
asp