Overview
A Dimension Table contains descriptive attributes (or fields) that are used to filter and group the facts in a fact table. Dimensions provide the 'who, what, where, when, why' of the data.
Examples
- Date/Time
- Product
- Customer
- Location
Dimension Table
A table in a star schema that contains attributes that describe business entities.
Categoryai