What is the Conformed dimension?

Conformed dimensions are dimensions that have the same meaning and content if referenced from different fact tables. This is for a dimension to be used in analyzing data from several related fact tables without any worry about data inconsistency.

In data warehousing and business intelligence, the conformed dimension is one way of pulling every fact table into pervasive uniformity. For example, you have a date dimension table used by the sales, purchase, finance, employee, inventory, and budget fact tables. It is important that the date dimension has the same structure, attributes, definitions, and domain values for each fact table. Having consistency in date dimensions would make it easy to use such measures in all these diverse fact tables while analyzing and comparing data.

An example of conformed dimensions is Date and Time.