Data quality

1. List five reasons why you think data quality is critical in a data warehouse.

2. Explain how data quality is much more than just data accuracy. Give an example.

3. Briefly list three benefits of quality data in a data warehouse.

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.

You are the staging area expert on the data warehouse project team for a large toy manufacturer. Discuss the four modes of applying data to the data warehouse. Select the modes you want to use for your data warehouse and explain the reasons for your selection.

Solution: