Follow Our FB Page << >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...

----------------------Diff b/w MOLAP and ROLAP?

Answers were Sorted based on User's Feedback

----------------------Diff b/w MOLAP and ROLAP?..

Answer / sandeep (cowboy), patni

MOLAP: OLAP which comminicates with the Multi Dimensional
ROLAP is Relational OLAP.

Is This Answer Correct ?    4 Yes 0 No

----------------------Diff b/w MOLAP and ROLAP?..

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

----------------------Diff b/w MOLAP and ROLAP?..

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

----------------------Diff b/w MOLAP and ROLAP?..

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

Post New Answer

More Cognos Interview Questions

what r the migration tools available in the market with respect to cognos such as impromptu reports are migrated to cognos reportnet??

2 Answers   Satyam,

I need your kind support. I have more than 6yrs of exp in s/w industry. I have worked on some DW technologies which are out dated. For almost 1 year I was on bench.During this bench period I learnt cognos on my own using online docs. Hence I am alligned to a project few months ago to work on cognos. Unfortunately after joining this project I did not get opportunity to work on cognos. I am working on different things apart from cognos. I should get job in another company. Otherwise I am gone. I am confident enough to get job on Cognos in another company. Please let me know is it possible to work on Cognos at lead position (as my current position is at lead level) without having real time experience. Your response is highly appreciated and I will be grateful to you. Thanks in advance Ganesh

2 Answers  

What are shortcuts? Where it can be used? What are the advantages?

0 Answers  

what is your project workflow and your role in the project?

5 Answers   Syntel,

How can I disable the drill-down for the last level of my dimensional hierarchy ????

1 Answers  

how to create measures and dimensions?

0 Answers   IBM,

whis meant by Thumbnails on cagnos?

2 Answers  

Write a SQL query which should fetch the 5th maximum salary of an employee from the table?

14 Answers   HCL,

Please Answer this Questions: 1.In FWM We have to create Hierarchies, Condition is we don't know the correct levels in the Hierarchies, in this case how can we find out the levels (year->Quarters->month->day)in data? 2. In FWM Standalone Filter is for Reusable purpose & Embedded Filter we cant resuse.but is this possible to convert the Embedded filter to standalone filter? 3.What are the differences between Relational Database Model & Multi Dimensional Database? 4.In Drill Down/ Drill Up, How to specify the limits for example in a report there is 6 Drill down is possible, but i want only 3 Drill downs, the report should not allow 4 Th Drill Down.How to make this ? 4. What are the limitations in Select and Search Prompt ?

0 Answers  

What is Cognos Powerhouse and what is it used for?

2 Answers   IBM, M Care,

What is difference between page break and section report?

0 Answers  

Cognos TM1 1. What are the different windows in Turbo Integrator? 2. What is the use of advanced window in Turbo Integrator? 3. What is TM1 Workflow. How do you create a process in that? 4. Where is Portlet used. What are differnt windows in portlet. How can you access TM1 web from portlet? Cognos 8. 1. What is Drill-on? 2.How do you implement row level security in Framework Manager? 3. How do you create tree prompt?

1 Answers   HSBC,