Interested to Buy Any Domain ? << Click Here >> for more details...
----------------------Diff b/w MOLAP and ROLAP?
- 4 Answers
- 7603 Views
- Bank Of America, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / sandeep (cowboy), patni
MOLAP: OLAP which comminicates with the Multi Dimensional
Analysis.
ROLAP is Relational OLAP.
| Is This Answer Correct ? | 4 Yes | 0 No |
Answer / uma
MOLAP: data stored in multi dimensional cube.ROLAP: relies on manipulating data from relational database. MOLAP:excellent performance cz data retrival is easy and also optimal for slicing and dicing,ROLAP:performance can be slow cz query time can be long if the data size is large. MOLAP: performs complex calculations and ROLAP difficult to perform. MOLAP: handles limited amt of data ROLAP: handles large amt of data
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / sharath
1) molap is multidimensional olap
rolap is relational olap.
2)in molap we can acess cubes but not in rolap.
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / suman palisetty
ROLAP has slower performance than MOLAP
ROLAP is more capable in handling large data volumes
| Is This Answer Correct ? | 0 Yes | 0 No |
How to select all in value prompt instead of cascade prompt?
what is dimention?explain dimentable with example?
What is set to be cardinality?
5. Which type of report you build more, list, crosstab or chart and why?
What is the difference between the standard and metrics folder?
how can i provide security to my reports in report studio?
How to hide value prompt box and list when run report?
What is difference between drill through and drill down?
what is dynamic sort?
Why we should go for cognos? when there are so many other BI(Reporting) tolls in front of us?
what are the uses of report studio,q.studio,analysis studio,event studio&.metric studi.
Q1. We have a crosstab report which is having product, region and Revenue information. Now the requirement is that we need to add a new column with the information 'High' and 'Low' just beside the Revenue column. If Revenue is high is should display as 'High' and if Revenue is low then it should display as 'Low'. Q2. If my Cube size is 2GB, now I have got the requirement to reduce it. What are the parameters I have to follow to reduce the cube size? Q3. How to get the 2nd highest salary of an employee without using any function (I mean without rownum etc.)? Q4. What is the difference between joins and scope relationship?
Teradata 
