What are conformed dimensions

Showing Answers 1 - 12 of 12 Answers

sri

  • 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.

jagadeswarreddy.palagani

  • 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  

  Was this answer useful?  Yes

jagadeswarreddy.palagani

  • 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  

  Was this answer useful?  Yes

khandera

  • Mar 2nd, 2006
 

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

  Was this answer useful?  Yes

ravi kumar guturi

  • Mar 9th, 2006
 

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

  Was this answer useful?  Yes

mootati raghavendroa reddy

  • Jul 28th, 2006
 

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

  Was this answer useful?  Yes

siva prtap

  • Dec 31st, 2006
 

hi,

the dimensions which are used across multiple datamarts are called as cd's

or

the dimensions which are fixed and reusable

  Was this answer useful?  Yes

chandrarekha

  • May 8th, 2007
 

Confirmed Dimensions: A dimension, Which can be used across multiple data marts
or
Dimesnsions, Which are reusable and fixed
Ex: Customer, time etc.

  Was this answer useful?  Yes

balaji

  • Nov 22nd, 2007
 

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

  Was this answer useful?  Yes

arehman626

  • Nov 24th, 2008
 

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.

  Was this answer useful?  Yes

Give your answer:

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

Answer Question

Click here to Login / Register your free account


 
Send   Reset

 

Related Answered Questions

 

Related Open Questions