MSBI Question And Answer By Hussain
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.
Share to Twitter
Share to Facebook
Share to Pinterest
Post a Comment
Post Comments (Atom)