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 is the data type of the surrogate key?
What is ods (operation data source)?
What is a core dimension?
Difference between PowerPlay transformer and power play reports?
Explain what are slowly changing dimensions?
How can you import tables from a database?
Suppose we want to display zero when null values coming to report how can we do that?
How much data hold in one universe.
What is batch processing?
What are different deliverables according to phases?
Explain what are the advantages data mining over traditional approaches?
What is a cube in data warehousing concept?
What is the difference between filter and lookup transformation?
What is load manager?
how much memory space occupied real time project (roughly)?