Whatis cube and why we are crating a cube what is diff between etl and olap cubes any budy ans plz?
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.