Snowflake Schema Modelling (Data Warehouse)

The snowflake schema is a normalized star schema. In a snowflake schema, the dimension tables are normalized. ... The advantage "in some cases may improve performance because smaller tables are joined" is not correct, as any join to a snowflake must pass

it.toolbox.com