Adding additional columns to facilitate error trapping and correction
Error detection, trapping, and correction are complex operations within the business intelligence and data warehouse solution. Adding them into ETL/ELT slows down the performance of the mappings and process flows. For this reason, it is recommended to add columns to the tables and mappings in order to detect, trap, and correct errors post mapping or process flow.
Getting ready
Identify all the fact tables within the data model, and understand their natural or business keys.
How to do it...
In a business intelligence or data warehouse solution, fact tables normally use surrogate keys (system generated columns to replace business or natural keys) to link dimensional information. ...
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.
