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

2.7. REVIEW QUESTIONS

  1. Name at least six characteristics or features of a data warehouse.

  2. Why is data integration required in a data warehouse, more so there than in an operational application?

  3. Every data structure in the data warehouse contains the time element. Why?

  4. Explain data granularity and how it is applicable to the data warehouse.

  5. How are the top-down and bottom-up approaches for building a data warehouse different? Discuss the merits and disadvantages of each approach.

  6. What are the various data sources for the data warehouse?

  7. Why do you need a separate data staging component?

  8. Under data transformation, list five different functions you can think of.

  9. Name any six different methods for information delivery.

  10. What are the three major types of metadata in a data warehouse? Briefly mention the purpose of each type.

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