WHAT IS A DIMENSION Table?
From the book I Am Datapedia!, published here free by the author.
Part of I Am Datapedia!
Questions 1–10 of 10
1. What role does a dimension table play in dimensional modelling?
2. Which questions do dimensions answer?
3. What does a dimension table typically contain?
4. Which attributes are listed for Dim_Customer in the loan approval warehouse?
5. What analytical capability do hierarchies within dimensions enable?
6. Which technique is used to manage business attributes such as customer segment that change over time in a dimension?
7. Why are dimensions described as the "face" of the data warehouse?
8. Which of the following is NOT listed as a trade-off of dimension tables?
9. How do dimensions differ between a star schema and a snowflake schema?
10. Which normal forms does dimensional modelling NOT aim to comply with?