Basics - What are conformed dimensions

GeekInterview.com > Interview Questions > Data Warehousing > Basics

Go To First | Previous Question | Next Question

Basics | Question 33 of 113

What are conformed dimensions

Total Answers and Comments: 8

Last Update: January 11, 2008

Sponsored Links

Best Rated Answer

—

Submitted by: Santanu Patra

A conformed dimension is a single, coherent view of the same piece of data throughout the organization. The same dimension is used in all subsequent star schemas defined. This enables reporting across the complete data warehouse in a simple format

Above answer was rated as good by the following members:
cfo_2016

June 29, 2005 06:48:09

Santanu Patra

RE: What are conformed dimensions

A conformed dimension is a single coherent view of the same piece of data throughout the organization. The same dimension is used in all subsequent star schemas defined. This enables reporting across the complete data warehouse in a simple format

Is this answer useful? Yes | No

1 0

Overall Rating: +1

July 29, 2005 19:30:36

jagadeswar reddy.Palagani

RE: What are conformed dimensions

Conformed Dimensions are the Dimensionswhich are common to two cubes .say 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

Is this answer useful? Yes | No

July 30, 2005 02:17:18

jagadeswar reddy.Palagani

RE: What are conformed dimensions

Is this answer useful? Yes | No

November 16, 2005 11:04:51

Ganesh

RE: What are conformed dimensions

if the dimension is 100 sharable across the starschema then this dimension is called as confirmed dimension.

Is this answer useful? Yes | No

September 07, 2006 03:32:00

srinu

RE: What are conformed dimensions

i thnk what jagdesh mentioned is correct and would like t o exchange notes with him.

Is this answer useful? Yes | No

June 11, 2007 17:30:53

Vivek

RE: What are conformed dimensions

Conformed Dimensions are either identical or strict mathematical subsets if the most granular detailed dimension. Dimensions are not called conformed if the attributes are labeled differently or contain different values.

Is this answer useful? Yes | No

December 07, 2007 07:42:32

Sivakumar.R

Member Since: December 2007 Contribution: 14

RE: What are conformed dimensions

Any Dimensional Table in a Schema which is Shared by Two Facts Tables are called Conformed dimensions.

Is this answer useful? Yes | No

January 11, 2008 06:03:44

jaggu_mandya

Member Since: January 2008 Contribution: 9

RE: What are conformed dimensions

In Integrated schema Design a dimension which can be shared across multiple fact tables is called Conformed Dimension.

Is this answer useful? Yes | No

Go To Top

User Name		Remember Me?
Password

Question Bank