Galaxy Schema

Share this topic

Galaxy Schema

From the book I Am Datapedia!, published here free by the author.

Part of I Am Datapedia!

Self-check

Questions 1–10 of 10

  1. 1. By what other name is the galaxy schema known?

    Question 1
  2. 2. How does the galaxy schema compare in complexity with the star and snowflake schemas?

    Question 2
  3. 3. How many fact tables does a galaxy schema contain?

    Question 3
  4. 4. What are the dimensions that connect multiple fact tables across multiple star schemas called?

    Question 4
  5. 5. What structural change does a galaxy schema make to a star schema?

    Question 5
  6. 6. Which schema answers the question of where conformed dimensions appear in dimensional modelling?

    Question 6
  7. 7. What is a reusable dimension in a galaxy schema?

    Question 7
  8. 8. Which of the following is NOT true of the galaxy schema?

    Question 8
  9. 9. The galaxy schema belongs to which data warehousing approach?

    Question 9
  10. 10. What do the small star schemas within a galaxy schema share?

    Question 10