Sunday 12 June 2011

What is a star schema?


Star schema is a data warehouse schema where there is only one  "fact table" and many denormalized dimension tables.
Fact table contains primary keys from all the dimension tables and other numeric columns columns of additive, numeric facts.



No comments:

Post a Comment