Snowflake for Constituent Dimensions

A series of constituent prefixed dimensions are snowflakes from the constituent dimension table in the warehouse:

• Constituent Address
• Constituent Demographic
• Constituent Information

These are mini dimensions that reduce processing and reporting time.

Views added in versions above 2.91 abstract these date keys into the fact tables to remove the snowflakes from the schema. So, there is a snowflake pattern when considered from the table level. But when considered from views, the star schema holds true.