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 is a staging area? Do we need it? What is the purpose of a staging area?
Explain what are the different types of join operations?
How many types of facts and what are they?
Explain why fact table is in normal form?
Explain what is the extension of file to save template?
What are the steps involved in creating dimensional modeling process?
"A dimension table is wide but the fact table is deep," explain the statement in your own words.
After the generation of a report to whom we have to deploy or what we do after the completion of a report?
Which technology should be used for interactive data querying across multiple dimensions for a decision making for a dw?
What are the steps to build the datawarehouse?
What is a real-time data warehouse? How is it different from near to real-time data warehouse?
Suppose we want to display zero when null values coming to report how can we do that?
Compare cold fusion with other programming languages?
What is an error log table in informatica occurs and how to maintain it in mapping?
Explain Association algorithm in Data mining?