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.
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.
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.
ReplyDeleteI think this is just to show the relationship not the table information.
ReplyDelete