# What are conformed dimensions

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

• 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

• 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

#### senkumar79 Profile Answers by senkumar79 Questions by senkumar79

• Oct 4th, 2005

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

#### vssaks Profile Answers by vssaks Questions by vssaks

• Jan 30th, 2006

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

#### khandera Profile Answers by khandera

• Mar 2nd, 2006

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

#### ravi kumar guturi

• Mar 9th, 2006

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

#### mootati raghavendroa reddy

• Jul 28th, 2006

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

#### 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

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

#### balaji

• Nov 22nd, 2007

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

#### arehman626 Profile Answers by 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.

#### matrixfree

• May 5th, 2016

Are the conformed dimensions the same as Common dimensions ? In Cognos Framework Manager ?

#### TimeBeing

• Jan 25th, 2017

A Dimension table which is used by multiple Fact Tables is called "Confirmed Dimension".