What is Snow Flake Schema design in database ? What’s the difference between Star and Snow flake schema ?

 Posted by Bharathi Cherukuri on 4/25/2012 | Category: Sql Server Interview questions | Views: 1566 | Points: 40

The denormalization of star schema is known as snow flake design.
Star schema is good when you do not have big tables in data warehousing. But when tables start becoming really huge it is better to denormalize. When you denormalize star schema it is nothing but snow flake design.

Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response