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 |
Explain why are oltp database designs not generally a good idea for a data warehouse?
what type of raid setup would you put your tx logs?
How to limit the max no of rows retrieved in the report?
Give some difference between oltp and olap.
Explain what are components of report studio?
Explain what is a staging area? Do we need it? What is the purpose of a staging area?
How do you setup Lo-cockpit?
Explain what are the various transformation available?
ware house management system is used?
Explain how does tuple-oriented relational calculus differ from domain-oriented relational calculus?
Is there any rownum object from which we can do this?
How to create different types of templates?