What is Snow Flake Schema design in database ? What’s the difference between Star and Snow flake schema ?
Interview question and answer by: Bharathi Cherukuri
| Posted on: 4/25/2012 | Category: SQL Server Interview questions
| Views: 417 | | 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.
| Alert Moderator
Found interesting? Add this to: