Answer Detail: RE: What is the main difference between star and snowf...

GeekInterview.com > Interview Questions > Data Warehousing

Print |

Question: What is the main difference between star and snowflake star schema? Which one is better and why?

February 02, 2007 01:48:45	#2
vijay	Member Since: Visitor Total Comments: N/A
RE: What is the main difference between star and snowf...
If u have one to may relation ship in the data then only we choose snowflake schema.As per the performance-wise every-one go for the Starschema.Moreover if the ETL is concenred with reporting means choose for snowflake bcz this schema provides more browising capability than the former schema.