What is a fact table in dimensional modelling?
- A A long narrow table of measurable events with foreign keys to dimensions
- B A wide table of descriptive attributes
- C A lookup table of codes
- D A summary of aggregated results
Answer
A long narrow table of measurable events with foreign keys to dimensions
Dimension tables provide the context you slice by, such as Date, Product and Customer, and relate to the fact table one to many.





