# Conformed Dimension

> One shared table, used by many fact tables, so their sums match.

**Field:** Data Engineering  
**Category:** Storage & Warehousing  
**Also known as:** Shared Dimension, Conformed Dimensions

## Think of it like

It is like one big calendar on the fridge. Mum, Dad and the kids all use it.

## Definition

A conformed dimension is a dimension table that many fact tables share. It has the same keys and the same meaning for all of them. A date or customer table is the usual example. Because sales and returns use the same customer table, a report can put them side by side. Teams agree on it once and then share it.

## Example

Sales, returns and web visits all join to one shared date table. A report can then show all three by week with no extra work.

## Why it matters

Without it, each team makes its own customer table. Their totals never quite match.

## Common mistake

Letting each team copy and tweak the shared table. A copy with one changed rule is no longer conformed.

## Three principles

- **Shared.** Many fact tables use it.
- **Same meaning.** Same keys, same labels.
- **Lines up reports.** Facts can sit side by side.

## Related terms

- [Dimension Table](https://learn.benibix.com/term/data/dimension-table)
- [Fact Table](https://learn.benibix.com/term/data/fact-table)
- [Dimensional Modeling](https://learn.benibix.com/term/data/dimensional-modeling)
- [Star Schema](https://learn.benibix.com/term/data/star-schema)
- [Data Mart](https://learn.benibix.com/term/data/data-mart)
- [Single Source of Truth (SSOT)](https://learn.benibix.com/term/data/single-source-of-truth)

![Two fact tables, sales and returns, each with a customer key and an amount, point to one highlighted customer table in the middle. Inside it, customer_key 1042 is marked as the surrogate key made by the warehouse, and email emma@example.com as the natural key from the source. An arrow leads to one report showing sales and returns per customer side by side.](https://learn.benibix.com/diagrams/dat3-conformed-dimension.svg)

---

Source: https://learn.benibix.com/term/data/conformed-dimension
Author: Behnia Zarei (a developer in Vienna, Austria, who builds and teaches data, AI and business intelligence at BENIBIX)
Publisher: BENIBIX Learn (https://learn.benibix.com/)
Last updated: 2026-11-16
Licence: CC BY 4.0 (https://creativecommons.org/licenses/by/4.0/). Quote freely with attribution.
