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

10.7. REVIEW QUESTIONS

  1. Discuss the major design issues that need to be addressed before proceeding with the data design.

  2. Why is the entity-relationship modeling technique not suitable for the data warehouse? How is dimensional modeling different?

  3. What is the STAR schema? What are the component tables?

  4. A dimension table is wide; the fact table is deep. Explain.

  5. What are hierarchies and categories as applicable to a dimension table?

  6. Differentiate between fully additive and semiadditive measures.

  7. Expla in the sparse nature of the data in the fact table.

  8. Describe the composition of the primary keys for the dimension and fact tables.

  9. Discuss data granularity in a data warehouse.

  10. Name any three advantages of the STAR schema. Can you think of any disadvantages of the STAR schema?

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