5.7. REVIEW QUESTIONS

  1. What are the essential differences between defining requirements for operational systems and for data warehouses?

  2. Explain business dimensions. Why and how can business dimensions be useful for defining requirements for the data warehouse?

  3. What data does an information package contain?

  4. What are dimension hierarchies? Give three examples.

  5. Explain business metrics or facts with five examples.

  6. List the types of users who must be interviewed for collecting requirements. What information can you expect to get from them?

  7. which situations can JAD methodology be successful for collecting requirements?

  8. Why are reviews of existing documents important? What can you expect to get out of such reviews?

  9. Various data sources feed the data warehouse. What are the pieces of information you need to get about data sources?

  10. Name any five major components of the formal requirements definition document. Describe what goes into each of these components.

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.