What is Molap and Rolap? What is Diff between Them?
Answer Posted / suba
multidimensional online analytical processing and
relational online analytical processing. In MOLAP data is
stored in form of multidimensional cubes. The advantages of
this mode is that it provides excellent query performance
and the cubes are built for fast data retrieval. All
calculations are pre-generated when the cube is created and
can be easily applied while querying data.In ROLAP, the
data is stored in relational databases this model gives the
appearance of traditional OLAP’s slicing and dicing
functionality. The advantages of this model is it can
handle a large amount of data and can leverage all the
functionalities of the relational database.
| Is This Answer Correct ? | 14 Yes | 0 No |
Post New Answer View All Answers
I have two universes created by two difference database can we join them in designer & report level? How
List any five applications of data warehouse.
Explain what is the advantages data mining over traditional approaches?
Explain in detail abt measure objects? And what is the use of it? How to create it?
What are target types on the server?
Explain what are the different types of data warehousing?
In my report contain product name, amount, country, sales person I want to create one prompt: sales territory.( Ex: asia, us, uk, aus), but territory column is not there in my model and source if u select the asia in prompt page-ll asian country results I want in report page I discussed with my friends and colleague, they told use the static choice function still I face this problem. If u know please tell me?
Explain what are the basic needs to join two sources in a source qualifier?
How can you implement many relations in star schema model?
Explain what are necessary tasks to install reportnet software?
Briefly state different between data ware house & data mart?
How to create diff. Types of templates?
Explain what is what are semi-additive and factless facts and in which scenario will you use such kinds of fact tables?
How to eliminate duplicate rows from flat file?
Explain what is the difference between olap and datawarehosue?