Conformed Dimensions
Conformed dimensions are the "glue" that holds the enterprise data warehouse together. They are dimensions designed to have consistent meaning, structure and content regardless of which fact tables use or reference them.
Example (A Conformed Date Dimension):
| date_key | full_date | year | month | day_of_week | quarter |
|---|---|---|---|---|---|
| 20240101 | 2024-01-01 | 2024 | Jan | Monday | Q1 |
| 20240102 | 2024-01-02 | 2024 | Jan | Tuesday | Q1 |
This dim_date can be shared by multiple unrelated fact tables. Any fact table can reference the 20240101 Date Key to represent January 1, 2024, ensuring enterprise-wide reporting consistency.