Answer Detail: RE: Explain the situations where snowflake is better than star schema

GeekInterview.com > Interview Questions > Data Warehousing > Basics

Print |

Question: Explain the situations where snowflake is better than star schema

February 02, 2008 21:57:25	#3
ghoshkunal123	Database Expert Member Since: January 2008 Total Comments: 4
RE: Explain the situations where snowflake is better than star schema
star schema is good for simple queries and logic. But snowflake schema is good for complex queries and logic. Snowflake schema is nothing but an extension of the star schema in which the dimension tables are further normalized to reducy redundancy. Hope this helps.