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

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?

March 03, 2008 03:12:28	#4
VVM.SP	Database Expert Member Since: March 2008 Total Comments: 7
RE: What is the main difference between star and snowflake star schema? Which one is better and why?
Star Schema: 1. Dimension tables directly connected to Fact Table 2. Contain de-normalized data 3. Data modifications are very easily 4. Highest flexibility 5. Best performance Snowflake Schema: 1.Hirarchy of dimension tables are connected to Fact Table 2. Contain partially normalized data 3. Data modifications are not easily 4. Compared with Star Schema, Snowflake Schema is complex. 5. Slow Performance