What is a Conformed Dimension?
Posted by Dylan Wan on January 18, 2007
A simple answer is that a conformed dimension is a dimension that is shared across fact tables.
A conformed dimension is important because it allows queries to be executed across star schemas. This activity is also called Drill Across. When you drill across, you are adding more data from another fact table to the existing rows.
Examples of obvious conformed dimensions include Customer, Location, Organization, Time, and Product.
Tod means Fox | ETL Subsystem 8: Data Conformance said
[...] are not too many other blog postings (ex: 1 2 3) on the topic of data conformity that truly dive into the topic. I would love to see more, as [...]