“Clean as you go” method

1. Give examples of four types of data quality problems.

2. What is the problem related to the reuse of primary keys? When does it usually occur?

3. Describe the functions of data correction in data cleansing tools.

1. Name five common sources of data pollution. Give an example for each type of source.

2. List six types of error discovery features found in data cleansing tools.

3. What is the “clean as you go” method? Is this a good approach for the data warehouse environment?

Assume that you are the data quality expert on the data warehouse project team for a large financial institution with many legacy systems dating back to the 1970s. Review the types of data quality problems you are likely to have and make suggestions on how to deal with those.

 

Solution: