Star Schema is a de-normalized multi-dimensional model. It contains centralized fact tables surrounded by dimensions table.
Dimension Table: It contains a primary key and description about the fact table.
Fact Table: It contains foreign keys to the dimension tables, measures and aggregates.
No comments:
Post a Comment