Translate to your Language

Thursday, December 27, 2012

Conformed Dimensions with example

by Unknown  |  in DW at  1:04 AM


In data warehousing, a conformed dimension is a dimension that has the same meaning to every fact table in the structure. Conformed dimensions allow facts and its measures to be accessed in the same way across multiple facts, ensuring consistent reporting across the enterprise.
A conformed dimension can exist as a single dimension table that relates to multiple fact tables within the same data warehouse, or as identical dimension tables in separate data marts.  


As you can see in the above figure,the time and cust dimensions are called confirmed dimensions as they are shared across multiple fact tables with the same meaning.


3 comments:

  1. cloverOctober 28, 2013 at 11:35 PM

    Spotted your write – ups, it’s cool. Very beneficial and interesting there are some ideas I haven’t heard before. Thanks for sharing.

    clover
    www.n8fan.net

    ReplyDelete
  2. UnknownFebruary 24, 2015 at 10:27 PM

    Thanks for sharing. :) this really made me have a clear picture of Conformed Dimension

    ReplyDelete
  3. UnknownAugust 8, 2015 at 5:17 AM

    Yes this really made me have a clear picture of Conformed Dimension @Thanks for sharing :)

    ReplyDelete

© Copyright © 2015Big Data - DW & BI. by