What is Molap and Rolap? What is Diff between Them?
Answer Posted / pratap gangula
In addition to the above answers, ROLAP storage models are better and faster for real time reporting & analytics whereas MOLAP storage models takes time to update itself. ROLAP models are slower because every query fired on cube has to satisfy RDBMS policies as well.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Explain what are the different types of join operations?
How to define a cube??
What are the stages of datawarehousing?
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?
Explain the hierarchies level data warehousing.
What is data cleaning? How can we do that?
what is an use case?
What are the different types of data warehousing?
What is index awareness in universe?
What is the difference between mapping parameter & mapping variable in data warehousing?
Explain what is the difference between stop and abort?
Explain the advantages of raid 1, 1/0, and 5. What type of raid setup would you put your tx logs.
What are necessary tasks to install reportnet software?
What is an error log table in informatica occurs and how to maintain it in mapping?
How did you plan your Data ware house project?