MSBI Question And Answer By Hussain
Pages
Home
Saturday, 2 June 2012
When should you use a Star and when should you use Snowflake Schema
Q: When should you use a Star and when should you use Snowflake Schema ?
Star Schema :
If the performance is the priority Than go for Star Schema, Since here dimension tables are denormalized.
Snowflake Schema :
If memory space is the priority than go for Snowflake Schema, since here dimension tables are normalized.
Newer Posts
Older Posts
Home
Subscribe to:
Posts (Atom)