Galaxy Schema
From the book I Am Datapedia!, published here free by the author.
Part of I Am Datapedia!
Questions 1–10 of 10
1. By what other name is the galaxy schema known?
2. How does the galaxy schema compare in complexity with the star and snowflake schemas?
3. How many fact tables does a galaxy schema contain?
4. What are the dimensions that connect multiple fact tables across multiple star schemas called?
5. What structural change does a galaxy schema make to a star schema?
6. Which schema answers the question of where conformed dimensions appear in dimensional modelling?
7. What is a reusable dimension in a galaxy schema?
8. Which of the following is NOT true of the galaxy schema?
9. The galaxy schema belongs to which data warehousing approach?
10. What do the small star schemas within a galaxy schema share?