What is a Conformed Dimensions?

Posted by: informaticareference on: 12/12/2011

• In: DataWareHousing Basics
• Leave a Comment

1. Confirmed Dimensions are nothing but Reusable Dimensions.
2. The dimensions which u r using multiple times or in multiple data marts.
3. Those are common in different data marts.

Conformed dimensions are either identical or strict mathematical subsets of the most granular, detailed dimension. Dimension tables are not conformed if the attributes are labeled differently or contain different values. Conformed dimensions come in several different flavors. At the most basic level, conformed dimensions mean the exact same thing with every possible fact table to which they are joined. The date dimension table connected to the sales facts is identical to the date dimension connected to the inventory facts.