Answer Detail: RE: Explain the situations where snowflake is better t...

GeekInterview.com > Interview Questions > Data Warehousing > Basics

Print |

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

November 11, 2007 03:34:06	#1
Ram	Member Since: Visitor Total Comments: N/A
RE: Explain the situations where snowflake is better t...
If the table space is not enough to maintain a STAR schema then we should go for Snowflake instead of STAR schema. i.e The table should be spilted in to multiple tables. Ex. if you want to maintain time data in one table like year, month, day in one table in star schema, you need to split this data into 3 tables like year, month, day in Snowflake schema.