Answer Posted / 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 |
Post New Answer View All Answers
How to calculate fact table granularity?
Why should we use data ware housing and how can you extract data for analysis with example?
i have scheduled a report in a job in the cognos8.3 which would send the reports to the respective user ,now the repot ran and is sent to the respective user but it contains some unwanted data. So based on the senario can any one tell me that can we recall back the report ??????
What are snapshots? What are materialized views & where do we use them?
What is the extension of file to save template?
What are diagrams?
what is user variable in affinium campaign? and some real time examples.
What is called dimensional modelling?
Explain what are necessary tasks to install reportnet software?
What are the different methods of loading dimension tables?
Explain Association algorithm in Data mining?
if you use oracle sql*loader , how do you transform data with it during loading?
what are the others of "bad files" and "discard files" when using sql*loader?
Explain the versions of reportnet?
What is the very basic difference between data warehouse and operational databases?