A Dimension is a descriptive data which describes the key.
The Dimensions are organized in a table called Dimension tables.
Dimension tables are De-normalized.
There is one-to-many relationship between dimensions
Each dimension is represented as a single table. The primary key in each dimension table is related to a foreign key in the fact table.
for eg. Customer, Territory, Employee, Product etc.
No comments:
Post a Comment