what are the similarities between ROLAP and MOLAP
Answer Posted / sivakrishna
you can see the data in matrix format in
rolap and molap....
| Is This Answer Correct ? | 6 Yes | 5 No |
Post New Answer View All Answers
Explain which columns go to the fact table and which columns go the dimension table?
What is normalization, first normal form, second normal form, third normal form?
Explain what type of indexing mechanism do we need to use for a typical datawarehouse?
What is a cube in data warehousing concept?
How to export mappings to the production environment?
Suppose you are filtering the rows using a filter transformation only the rows meet the condition pass to the target. Tell me where the rows will go that does not meet the condition 333 after we create a scd table, can we use that particular dimension as a dimension table for star schema?
Explain what are the advantages of query studio compared to report studio?
What is the difference between aggregate table and materialized view?
How would you write a simple stored procedure in tsql which takes a movie_id and returns all the directors associated with it?
For faster process, what we will do with the universe?
What is mean by aggregate aware?
Explain what are the basic needs to join two sources in a source qualifier?
What are the stages that are required in data warehousing?
Explain conformed fact?
How to performance tune reports?