Answer Posted / fatma
ROLAP Cubes: stands for Relational OLAP. In ROLAP cubes a
copy of data from the fact table is not made and the data
aggregates are stored in tables in the source relational
database. A ROLAP cube is best when there is limited space
on the Analysis Server and query performance is not very
important. ROLAP local cubes contain the dimensions and
cube definitions but aggregates are calculated when they
are needed. ROLAP cubes require less storage space than
MOLAP and HOLAP cubes.
| Is This Answer Correct ? | 4 Yes | 1 No |
Post New Answer View All Answers
What is perform recovery?
What are session timeout and application timeout?
How to test report in reportnet?
Suppose your client wants to ensure only specific users can create reports in query studio with other users creating reports using report studio. How can this be accomplished?
What is the difference between view materialized view and view?
How to join 3 database like flat file, oracle, db2 in informatrica?
Explain clustering algorithm?
Explain what type of indexing mechanism do we need to use for a typical datawarehouse?
What is a source qualifier?
Explain what are the different methods of loading dimension tables?
What is the difference between view filter and report filter?
After we create a scd table, can we use that particular dimension as a dimension table for star schema?
If two relational tables are connected to sq trans, what are the possible errors it will be thrown?
Explain what is partitioning? What are the types of partitioning?
How can we run the graph? How can we schedule the graph in unix?