Information about source systems, transformations, and load processes are important to help warehouse users and administrators find the data that they need. Consequently, this course also describes meta data capture throughout the warehousing process. Delivering high quality data is a significant factor in building a successful data warehouse that meets end-user needs. Students will be introduced to techniques to identify and fix data quality problems using data integrity and data correctness rules. The rules may be applied to cleanse data at the source, during transformation, or at the data warehousing target.
Exercises reinforce data cleansing techniques and support the skills to build a data quality plan.