Transaction Fact
Simplest Fact table, capturing data at lowest level.
What is the GRAIN here?
By date, time, store, product
This is a Transaction Fact table. It captures the lowest amount of data.
It helps you to find
What are the sales of Store 001?
What is the sale of a particular product per day?
- Simple structure.
- Keeps most detailed level data.
- Easy to aggregate.