GeekInterview.com
Series: Subject: Topic:
Question: 105 of 133

What are conformed dimensions

Asked by: Interview Candidate | Asked on: Aug 1st, 2005
Showing Answers 1 - 12 of 12 Answers
sri

Answered On : Jun 17th, 2005

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.

Yes  1 User has rated as useful.
  
Login to rate this answer.
jagadeswarreddy.palagani

Answered On : Aug 1st, 2005

Conformed dimentions are dimensions which are common to the cubes.(cubes are the schemas contains facts and dimension tables)  Consider Cube-1 contains F1,D1,D2,D3 and Cube-2 contains F2,D1,D2,D4 are the Facts and Dimensions  here D1,D2 are the Conformed Dimensions  

  
Login to rate this answer.
jagadeswarreddy.palagani

Answered On : Aug 1st, 2005

Conformed dimentions are dimensions which are common to the cubes.(cubes are the schemas contains facts and dimension tables)  Consider Cube-1 contains F1,D1,D2,D3 and Cube-2 contains F2,D1,D2,D4 are the Facts and Dimensions  here D1,D2 are the Conformed Dimensions  

  
Login to rate this answer.

If a table is used as a dimesion table for more than one fact tables. then the dimesion table is called conformed dimesions.

  
Login to rate this answer.

Confirmed dimensions are the dimensions which can be used in multiple star schemascorrect me if i am wrong.

  
Login to rate this answer.
khandera

Answered On : Mar 2nd, 2006

View all answers by khandera

Conformed Dimensions are the one if they share one or more attributes whose values are drawn from the same domains.

  
Login to rate this answer.
ravi kumar guturi

Answered On : Mar 9th, 2006

The dimensions which is used more than one fact table is called conformed dimensions

  
Login to rate this answer.
mootati raghavendroa reddy

Answered On : Jul 28th, 2006

Comformed dimenssion is the dimenssion which is used in more than one star schema

  
Login to rate this answer.
siva prtap

Answered On : Dec 31st, 2006

hi,the dimensions which are used across multiple datamarts are called as cd'sorthe dimensions which are fixed and reusable

  
Login to rate this answer.
chandrarekha

Answered On : May 8th, 2007

Confirmed Dimensions: A dimension, Which can be used across multiple data martsor Dimesnsions, Which are reusable and fixedEx: Customer, time etc.

  
Login to rate this answer.
balaji

Answered On : Nov 22nd, 2007

A dimension which can be shared with multiple fact tables such dimensions are know as conformed dimension.

  
Login to rate this answer.
arehman626

Answered On : Nov 24th, 2008

View all answers by arehman626

A conformed dimension is a set of data attributes that have been physically
implemented in multiple database tables using the same structure, attributes,
domain values, definitions and concepts in each implementation.
Unlike in operational systems where data redundancy is normally avoided, data
replication is expected in the Data Warehouse world. To provide fast access and
intuitive "drill down" capabilities of data originating from multiple
operational systems, it is often necessary to replicate dimensional data in Data
Warehouses and in Data Marts.
Un-conformed dimensions imply the existence of logical and/or physical
inconsistencies that should be avoided.

  
Login to rate this answer.

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

Related Open Questions

Ads

Connect

twitter fb Linkedin GPlus RSS

Ads

Interview Question

 Ask Interview Question?

 

Latest Questions

Interview & Career Tips

Get invaluable Interview and Career Tips delivered directly to your inbox. Get your news alert set up today, Once you confirm your Email subscription, you will be able to download Job Inteview Questions Ebook . Please contact me if you there is any issue with the download.