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
Explain what are components of reportnet?
How can we run the graph? What is the procedure for that?
Explain what is the limit to the number of sources and targets you can have in a mapping?
What are data modeling and data mining?
What are the types of SCD?
What are the difference between snow flake and star schema? What are situations where snow flake schema is better than star schema to use and when the oppositeis true?
After the generation of a report to whom we have to deploy or what we do after the completion of a report?
Explain what is batch and describe about types of batches?
Explain what are fact, dimension, and measure?
Explain is fact table?
How to calculate fact table granularity?
Where the applications and where ware house management system is used?
What is data cleaning? How can we do that?
What is the difference between data warehouse and operational systems?
Difference between cold fusion mx 6 and cold fusion mx 7?