Is Data Quality confined to using a specific tool? Of course not. It begins right from Data Modelling. Effective tracking and monitoring of Data Quality doesnot necessarily need a Data Quality tool for instance. (Though I am sure the Data Quality tools make it easier). It can be delivered by a normal ETL job, if the Data Modeling is done right.
Kimball talks about about the modelling aspects of gathering information about Data Quality
He makes some interesting points about how to manage the audit "dimension" tables
....Our resulting audit dimension record should be of low cardinality compared to the fact table. All the fact table records loaded in the same batch run of the ETL system will probably have the same audit key, except for the few exceptional records that you have to modify or artificially supply. These exceptional records will generate only a few more audit keys......
The Full article can be accessed here.
Monday, May 26, 2008
Subscribe to:
Post Comments (Atom)
2 comments:
Where can I access the complete article
http://www.information-management.com/issues/20071001/1093610-1.html -- Complete Artice can be found here..
Post a Comment