Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

What is a Conformed Dimension?

April 26, 2017conformed dimension

0

Posted

What is a Conformed Dimension?

1 Answer

0

Posted

Confirmed dimension is a dimension modelling technique promoted by Ralph Kimball. A Conformed Dimension is a dimension that has a single meaning and content throughout a datawarehouse. A confirmed dimension can be used in any star schema. For example Time/Calendar dimension is normally used in all star schemas so can be designed once and used with many fact tables across a data warehouse.