What are CUBES?
Answers were Sorted based on User's Feedback
Answer / vijay
Cubes are also called as business process.Cube is the
logical representation of multidimentional data.The edge of
the cube contains dimention and the body of the cube
contain data.
| Is This Answer Correct ? | 8 Yes | 5 No |
Answer / harshad
In Data warehouse environments typically view data in the
form of a star schema, OLAP environments view data in the
form of a hierarchical cube. A hierarchical cube
includes the data aggregated along the rollup hierarchy of
each of its dimensions and these aggregations are combined
across dimensions. It includes the typical set of
aggregations needed for business intelligence queries.
| Is This Answer Correct ? | 4 Yes | 5 No |
What is an OLAP (On-line Analytical processing) system?
Explain what is the metadata extension?
What are the different methods of loading dimension tables?
What is data mart in data warehouse?
Explain what are the various methods of getting incremental records or delta records from the source systems?
What are the different types of schemas used in data warehousing?
Explain dimensional modelling?
How many ways we test the universe & Report?
Which are the olap tools available that are supported by oracle?
What are aggregate transformation?
Explain ddl (data definition language)?
Explain the difference between data ware house & data mart?