Skip to main content

snow flake schema in data warehouse



Snow flake schema - In Snowflake schema each dimensional has a primary dimensional table to which it will join to another dimensional table. The primary dimensional table is the only table which join to the fact table.


An extension of star schema by adding one or more dimensional table, and join it to dimensional table of star schema.

snow flake schema
snow flake schema




Comments