Answer Detail: RE: What are conformed dimensions

GeekInterview.com > Interview Questions > Data Warehousing > Basics

Print |

Question: What are conformed dimensions

June 06, 2005 18:09:29	#1
sri	Member Since: Visitor Total Comments: N/A
RE: What are conformed dimensions
They are dimension tables in a star schema data mart that adhere to a common structure, and therefore allow queries to be executed across star schemas. For example, the Calendar dimension is commonly needed in most data marts. By making this Calendar dimension adhere to a single structure, regardless of what data mart it is used in your organization, you can query by date/time from one data mart to another to another.