WHAT IS A FACT 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 does a fact table store in dimensional data modelling?
2. Which question do facts answer?
3. Which three kinds of content does a fact table typically contain?
4. What is the grain of a fact table?
5. What can happen if the grain of a fact table is not clearly defined?
6. Which measure is given as an example of an additive fact?
7. Why is Loan Balance described as a semi-additive fact?
8. How should a non-additive fact such as Interest Rate be handled in analysis?
9. Why can a fact table not stand alone?
10. Which of the following is NOT a listed characteristic of fact tables?