GeekInterview.com
  I am new, Sign me up!
 
GeekInterview.com  >  Interview Questions  >  Data Warehousing  >  Basics
Go To First  |  Previous Question  |  Next Question 
 Basics  |  Question 29 of 113    Print  
What are conformed dimensions

  
Total Answers and Comments: 12 Last Update: November 25, 2008   
  
 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    1    2    >     Last »  
June 17, 2005 18:09:29   #1  
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   #2  
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   #3  
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
October 04, 2005 03:04:49   #4  
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   #5  
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   #6  
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   #7  
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   #8  
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   #9  
siva prtap        

RE: What are conformed dimensions

hi

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

or

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    1    2    >     Last »  


 
Go To Top


 Sponsored Links

 
About Us -  Privacy Policy -  Terms and Conditions -  Contact -  Ask Question -  Propose Category -  Site Updates 

Copyright © 2005 - 2009 GeekInterview.com. All Rights Reserved

Page copy protected against web site content infringement by Copyscape