Designing ETL data reconciliation routines
Reconciliation routines are automated ways to check the data integrity using predefined business rules. These routines look at the content of the information and record the results. Information is then compared to determine if it matches.
Getting ready
Identify the business rules to compare and validate information as it flows through the business intelligence and data warehouse solution from the source environment to the target environment. Review your data lineage from Chapter 8, Analyzing the Sources, specifically for fact table loads. Along the stream for fact loads are excellent places for data reconciliation scripts.
How to do it...
Proving data integrity to the business users is key. Automating this ...
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.
