snowflake structure

snowflake structure

In a data warehouse, the structure that is created when highly repeated fields are placed into separate tables. The resulting diagram has short and long branches extending from the original dimension that resemble the irregularities of a snowflake. Snowflake structures are generally not recommended as they slow down browsing the data.