Open AccessETL Auto Reconciliation
Author(s) -
J A Jos,
U Bragadishwaran
Publication year - 2010
Publication title -
mapana journal of sciences
Language(s) - English
Resource type - Journals
ISSN - 0975-3303
DOI - 10.12723/mjs.17.5
Subject(s) - data warehouse , computer science , data transformation , process (computing) , database , data extraction , data quality , data source , clarity , quality (philosophy) , transformation (genetics) , data mining , engineering , operating system , metric (unit) , biochemistry , operations management , chemistry , philosophy , medline , epistemology , political science , law , gene
Extraction, transformation and Loading (ETL) is the process of storing data into the data warehouse. Errors in the ETL process con result in wrong data being stored. This paper introduces an automated approach to reconcile the source data with data stored in the data warehouse. This ensures that data in the warehouse is consistent with the source data and all stakeholders have clarity on the quality of the data. The ETL Unit presented in the paper can be considered as a template/ design pattern to implement this strategy. The pattern will help to for implementing both integrated and independent Auto Reconciliation.