Infosys

  www.infosys.com
  www.infosys.com

Interview Question

Engineer Interview Minneapolis, MN

what is star and snowflake schema

Answer

Interview Answer

1 Answer

1

In computing, a snowflake schema is a logical arrangement of tables in a multidimensional database such that the entity relationship diagram resembles a snowflake in shape. The snowflake schema is represented by centralized fact tables which are connected to multiple dimensions.

The snowflake schema is similar to the star schema. However, in the snowflake schema, dimensions are normalized into multiple related tables, whereas the star schema's dimensions are normalized with each dimension represented by a single table

ibrahim1105 on Jun 26, 2012

Add Answers or Comments

To comment on this, Sign In or Sign Up.