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 create different types of templates?
How to test report in reportnet?
What needs to be done when the database is shutdown?
What is your spectra photometer working principles?
Explain what are the possible data marts in retail sales?
if you use oracle sql*loader , how do you transform data with it during loading?
Explain difference between snow flake and star schema.
Code the tables statement to produce a multi-level frequency?
What is incremintal loading?
What are the types of SCD?
What are the different models used in cluster analysis?
Explain the difference between dw and bi?
How to reduce warnings?
How to load the time dimension?
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?