Dimension Table features
- It provides the context /descriptive information for fact table measure-ments.
- Provides entry points to data.
- Structure of Dimension - Surrogate key , one or more other fields that compose the natural key (nk) and set of Attributes.
- Size of Dimension Table is smaller than Fact Table.
- In a schema more number of dimensions are presented than Fact Table.
- Surrogate Key is used to prevent the primary key (pk) violation(store historical data).
- Values of fields are in numeric and text representation.
Fact Table features
- It provides measurement of an enterprise.
- Measurement is the amount determined by observation.
- Structure of Fact Table - foreign key (fk), Degenerated Dimension and Measurements.
- Size of Fact Table is larger than Dimension Table.
- In a schema less number of Fact Tables observed compared to Dimension Tables.
- Compose of Degenerate Dimension fields act as Primary Key.
- Values of the fields always in numeric or integer form
