----------------------Diff b/w MOLAP and ROLAP?
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 |
What are all the types of indexes in Cognos?
Hi Techies..., can any one please answer me what is called unit testing ? how to do it and what are the steps involves in it? thanks for your answer......
how can we improve performance of the reports?
How to hide/unhide the prompts which are not used by unauthorized users?
Can you define folder?
what is meaning by Master detailed relationship ? please explain one example
How can we improve performance in framework manager level?
What do you mean by drill across?
Synchroness 1.What are hash prompts? Ans: Tree prompts in which hierarchies can be seen,they can be said as hash prompts. 2.User wants to see 5 more coloums in the report.We have package and data base,how will u implement using it in report.? Ans: 3.What is automatic optimization?what is optimization?what are the properties you set for optimization in report studio? 4.what is command to display first 10 records from a table? IGATE 1.In FM if we change a fact symbol to attribute,will it effect the report? 2.If a report is slow in generating output. How do u perform tuning? How do u reduce joins in sql? Using left outer join is it going to improve the report performance? IBM 1.How do you configure ? 2.How do you drill through report from RS to Analysis studio?
write a query to display to 10 max record from the employee table?
9. What was the most complex type of report you dealt with?
Write some methods to apply securities in framework manager model?