Basics - What are conformed dimensions

GeekInterview.com > Interview Questions > Data Warehousing > Basics

Go To First | Previous Question | Next Question

Basics | Question 29 of 110

What are conformed dimensions

Total Answers and Comments: 11

Last Update: November 23, 2007

Sponsored Links

Best Rated Answer

—

No best answer available. Please pick the good answer available or submit your answer.

Sorting Options

Page 1 of 2

« First

Last »

June 17, 2005 18:09:29

sri

RE: What are conformed dimensions

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.

Is this answer useful? Yes | No

August 01, 2005 02:23:13

jagadeswarreddy.palagani

RE: What are conformed dimensions

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

Is this answer useful? Yes | No

August 01, 2005 02:23:27

jagadeswarreddy.palagani

RE: What are conformed dimensions

Is this answer useful? Yes | No

October 04, 2005 03:04:49

senkumar79

Member Since: October 2005 Contribution: 17

RE: What are conformed dimensions

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

Is this answer useful? Yes | No

January 30, 2006 00:47:24

vssaks

Member Since: January 2006 Contribution: 6

RE: What are conformed dimensions

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

Is this answer useful? Yes | No

March 02, 2006 00:54:37

khandera

Member Since: March 2006 Contribution: 1

RE: What are conformed dimensions

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

Is this answer useful? Yes | No

March 09, 2006 00:59:08

ravi kumar guturi

RE: What are conformed dimensions

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

Is this answer useful? Yes | No

July 28, 2006 08:58:58

mootati raghavendroa reddy

RE: What are conformed dimensions

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

Is this answer useful? Yes | No

December 31, 2006 09:31:04

siva prtap

RE: What are conformed dimensions

hi,

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

the dimensions which are fixed and reusable

Is this answer useful? Yes | No

May 08, 2007 12:17:30

#10

chandrarekha

RE: What are conformed dimensions

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

Is this answer useful? Yes | No

Page 1 of 2

« First

Last »

Go To Top