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