| Fact Table | Dimension Table |
|---|---|
| Stores business transactions | Stores descriptive information |
| Contains measures | Contains attributes |
| Large volume of records | Relatively smaller |
| Examples: Sales Amount, Quantity | Examples: Product Name, Customer Name |
Fact tables answer "what happened" while dimension tables answer "who, when, where, and how".
First read the answer fully, then try to explain it in your own words. After that, open a few related questions and compare the concepts. This method helps you remember the topic for a longer time and improves exam preparation.