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.
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.
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's
or
the 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 marts
or
Dimesnsions, Which are reusable and fixed
Ex: Customer, time etc.
Login to rate this answer.
balaji
Answered On : Nov 22nd, 2007
A dimension whichcan be shared with multiple fact tables such dimensions are know as conformed dimension.
Login to rate this answer.
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.
