Designing ETL error trapping and detection routines
There are many ways in which you can detect and trap errors. Tools such as Oracle Warehouse Builder and Oracle Data Integrator provide some capabilities to detect data quality errors and provide mechanisms to correct the issues. The Oracle database allows you to add constraints to your data model (primary, foreign, unique, and check constraints) to enforce data integrity. They are useful and help to trap some errors; the problem with them is in detecting an error. For example, if you get a duplicate key error and are using a primary key constraint with bulk transformation within Oracle, a few things will happen. The first is the bulk transformation will encounter an error and potentially stop. ...
Get Business Intelligence Cookbook: A Project Lifecycle Approach Using Oracle Technology now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
