GeekInterview.com
  I am new, Sign me up!
 
GeekInterview.com  >  Interview Questions  >  Data Warehousing  >  Basics
Go To First  |  Previous Question  |  Next Question 
 Basics  |  Question 40 of 113    Print  
What is a CUBE in datawarehousing concept?

  
Total Answers and Comments: 5 Last Update: August 20, 2007   
  
 Sponsored Links

 
 Best Rated Answer
—
Submitted by: desaial
 
CUBE is used in DWH for representing multidimensional data logically.  Using the cube, it is easy to carry out certain activity e.g. drill down / drill up, slice and dice, etc. which enables the business users to understand the trend of the business. It is good to have the design of the cube in the star schema so as to facilitate the effective use of the cube.

Above answer was rated as good by the following members:
phdsong
July 28, 2005 05:14:06   #1  
murali        
RE: What is a CUBE in datawarehousing concept?
Cubes are logical representation of multidimensional data.The edge of the cube contains dimension members and the body of the cube contains data values.
 
Is this answer useful? Yes | No
August 07, 2005 18:52:05   #2  
jagadeswar reddy.Palagani        
RE: What is a CUBE in datawarehousing concept?
Cube is a logical schema which contains facts and dimentions
 
Is this answer useful? Yes | No
December 06, 2005 12:48:01   #3  
pat        
RE: What is a CUBE in datawarehousing concept?
cubes r muti-dimensional view of dw or data marts. it is designed in a logical way to drill slice-n-dice. every part of the cube is a logical representation of the combination of facts-dimension attribs.
 
Is this answer useful? Yes | No
September 20, 2006 16:32:05   #4  
jahnavi.s Member Since: September 2006   Contribution: 2    
RE: What is a CUBE in datawarehousing concept?
yes cube is a logical representation of data.12 steps are required for the creation of cubes.its mainly used for analysis purpose. we can analyse which product can be sold more in which country all these we available in the cube by performing operatoins like roll-up drill-down slice and dice
 
Is this answer useful? Yes | No
August 20, 2007 10:20:23   #5  
desaial Member Since: August 2007   Contribution: 6    
RE: What is a CUBE in datawarehousing concept?
CUBE is used in DWH for representing multidimensional data logically. Using the cube it is easy to carry out certain activity e.g. drill down / drill up slice and dice etc. which enables the business users to understand the trend of the business. It is good to have the design of the cube in the star schema so as to facilitate the effective use of the cube.
 
Is this answer useful? Yes | NoAnswer is useful 1   Answer is not useful 0Overall Rating: +1    


 
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