Designing Snowflake Schema
Snowflake Schema: A snowflake schema is a term that describes a star schema structure normalized through the use of outrigger tables. i.e dimension table hierarchies are broken into simpler tables. In Star Schema example we had 4 dimensions like location, product, time, organization and a fact table (sales). In Snowflake schema, the example diagram shown…