Changed data is extracted during daily/nightly batch runs of the Business Intelligence ETL processes. To ensure that only changed data is extracted, ETL processes must run successfully with zero warnings/errors.
Infosphere is not configurable and enforces zero tolerance for warnings/errors with all ETL's, hence any errors/warnings will result in the ETL process being marked as failed
Oracle Warehouse Builder is configurable, allowing ETL processes to be flagged as failing. This is controlled by the 'Maximum number of errors' property value.
Default runtime behavior in Oracle Warehouse Builder:
To ensure that all ETL processes are correctly flagged as either successful or failed, a zero tolerance to warnings/errors is enforced by the build process which sets the 'Maximum number of errors' property to zero for all ETL's. This is set during the import process.
Two new build commands have been introduced which are embedded in the import process but can be run individually: