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

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.

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