The best definition about Conformed dimension is that it is dimension which is consistent across the whole business and can be linked with all the facts to which it relate.
(or)
In simple words Dimension Table Join with More Then One Fact Table That is Called Conformed Dimension.
Ex:Time Dimension.
Date Dimension because its attributes (day, week, month, quarter, year, etc.) have the same meaning across all the facts. The month January will be the same for all the departments in an organization.
Uses Of Conformed Dimension:
(or)
In simple words Dimension Table Join with More Then One Fact Table That is Called Conformed Dimension.
Ex:Time Dimension.
Date Dimension because its attributes (day, week, month, quarter, year, etc.) have the same meaning across all the facts. The month January will be the same for all the departments in an organization.
Uses Of Conformed Dimension:
- Conformed dimensions should be defined at the most granular level so that each record in these tables corresponds to a single record in the fact able.
- Data should never be defined for a specific function or department. Good data is one, which is widely shareable and conformed dimensions help in doing that.
- Conformed dimension ensures that the facts and measures are the same across all facts and data marts so that reporting is consistent.
- A conformed dimension is important because it allows to Drill Across. i.e linking of two different fact tables with same granularity.
