GeekInterview.com
   Home |  Tech FAQ  |   Interview Questions |  Placement Papers |  Tech Articles |  Learn |  Freelance Projects |  Online Testing |  Geeks Talk |  Job Postings |  Knowledge Base | Site Search |  Add/Ask Question

  GeekInterview.com  >  Interview Questions  >  Data Warehousing  >  Basics

 Print  |  
Question:  what is cube and why we are crating a cube what is diff between etl and olap cubes any budy ans plz?




November 11, 2006 08:54:17 #1
 Shiva   Member Since: Visitor    Total Comments: N/A 

RE: what is cube and why we are crating a cube wha...
 

 Any schema or Table or Report which gives you meaningful information  of  one attribute  wrt more than one attribute is called  a cube.

For Ex: In a product table with Product ID and Sales colomns , we can analyse Sales  wrt to Prodcut Name , but if you analyse Sales wrt Product as well as Region( region being attribute in Location Table) the report or Resultant table or schema would be Cube.

ETL Cubes : Built in the staging area to load frequently accessed reports  to the target.

Reporting Cubes : Built after the actual load of all the tables to the target depending on the customer requirement for his business analysis.

     

 

Back To Question