Saturday, June 19, 2010

BI: Dimensional Model - Snowflake schema architecture

Snowflake schema architecture is a more complex variation of a star schema design. The main difference is that dimensional tables in a snowflake schema are normalized, so they have a typical relational database design.


  1. I think City table should have city_key and not store_key. Store table should have city_key along with store_key. Same applies to State and Region tables.

  2. I think this is just to show the relationship not the table information.