O'Reilly logo

DATA WAREHOUSING FUNDAMENTALS: A Comprehensive Guide for IT Professionals by Paulraj Ponniah

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

13.7. REVIEW QUESTIONS

  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.

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

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

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

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

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

  9. What is the "clean as you go" method? Is this a good approach for the data warehouse environment?

  10. Name any three types of participants on the data quality team. What are their functions?

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required