Chapter 11. Error Management
If only everything we developed and used worked perfectly each and every time! Unfortunately in the real world the topic of error management—how to discover, diagnose and correct errors—is a fundamental part of "business as usual" operations. It's also one of those areas of knowledge and skill which constantly grows with experience and familiarity with a product or system.
There are three main categories of errors and error management when it comes to ODI, namely:
Data errors: These occur when we encounter "bad" data during data integration tasks. This subject area covers ODI's error tables, detecting and diverting non-compliant records, and correcting and recycling error records—essentially ODI's basic data quality capabilities and mechanisms.
Execution errors: These occur when one or more steps in an interface, procedure, package, or scenario fail to complete successfully. We've already spent some time looking at execution logs in Operator Navigator of ODI...
