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

January 01, 2008 01:32:55	#2
jaggu_mandya	Member Since: January 2008 Total Comments: 9
RE: Explain the situations where snowflake is better than star schema
In Star Schema When we try to access many attributes or few attributes from a single dimension table the performance of the query falls. So we denormalize this dimension table into two or sub dimensions. Now the same star schema is transformed into snow Flake schema. By doing so the performance improves