Star Schema
From the book I Am Datapedia!, published here free by the author.
Part of I Am Datapedia!
Questions 1–10 of 10
1. Whose data warehousing approach do the star schema and snowflake schema belong to?
2. According to Ralph Kimball, which modelling approach must be used for data warehouses and data marts?
3. In a star schema, what sits in the middle of the model?
4. In a star schema, how are the dimensions related to the fact table?
5. In the star schema example with a Sales fact table, which of the following is given as a dimension?
6. What makes up the primary key of the fact table in a star schema?
7. When a report or query is created against a star schema, how many joins are needed to reach any dimension?
8. Which of the following is NOT a dimension named in the Sales star schema example?
9. In which kinds of data store is the star schema applied?
10. In the star schema example, which table is the fact table?