You are designing an enterprise star schema that will consolidate data from three independent data
marts. One of the data marts is hosted on SQL Azure. Most of the dimensions have the same
structure and content. However, the geography dimension is slightly different in each data mart. You
need to design a consolidated dimensional structurethat will be easy to maintain while ensuring
that all dimensional data from the three original solutions is represented. What should you do?
A.
Create a junk dimension for the geography dimension.
B.
Implement change data capture.
C.
Create a conformed dimension for the geography dimension.
D.
Create three geography dimensions.
In data warehousing, a conformed dimension is a dimension that has the same meaning to every fact with which it relates. Conformed dimensions allow facts and measures to be categorized and described in the same way across multiple facts and/or data marts, ensuring consistent reporting across the enterprise.