Hi all,

Conformed Dimension - Can anyone briefly explain about the conformed Dimension and how they are differnet from dimensions?

Thanks in adv...

Hi all,
A small update on Conformed Dimension from my side -

Confirmed dimension is a dimension modeling technique promoted by Ralph Kimball.

A Conformed Dimension is a dimension that has a single meaning and content throughout a data warehouse. A conformed 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.

The use of conformed dimensions and shared measures is the primary way a set of data marts can be united into one consolidated data warehouse. 

Conformed dimensions are what which are common between data marts and make the drill across possible.   

Conformed dimensions
Conformed dimensions can be used to analyze facts from two or more data marts. Suppose you have a “shipping� data mart (telling you what you’ve shipped to whom and when) and a “sales� data mart (telling you who has purchased what and when). Both marts require a “customer� dimension and a “time� dimension. If they’re the same dimension, then you have conforming dimensions, allowing you to extract and manipulate facts relating to a particular customer from both marts, answering questions such as whether late shipments have affected sales to that customer.

Conformed facts
In addition to conformed dimensions, you need conformed facts. Conforming a fact needs standardizing the definitions of terms across individual marts. Often, different divisions or departments use the same term in different ways. Does “revenue� refer to “gross revenue� or “adjusted revenue�? Does “units shipped� refer to cases of items or individual items?so consider this also.

Admin -
Merged & moved this topic from Informatica Board to here.

@mrinal - Don't post two threads with the same content.