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.

Get DATA WAREHOUSING FUNDAMENTALS: A Comprehensive Guide for IT Professionals now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial