1. Categories >> Software >> Data Warehouse >> Cognos
  2. Suggest New Category

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

Question Posted / arkchowdary

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
Analysis.
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 is textsource variable

2 Answers   HCL,

How to Create users in cognos Access Manager from 1) front end 2) back end

1 Answers   TCS,

How to create users and permissions in cognos?

4 Answers   IBM,

Guys... which difficult you faced in your projects that should be difficult to you not to others... any one can explain but should be clear steps... and with examples... how you handle that......?

0 Answers   CTS,

What are the themes in a data warehouse?

0 Answers  




What condition do we use in Cognos when multiple path exits to reach the fact table.(i.e in BOXI we use CONTEXT when multiple path exit)

0 Answers  

what is the use of layout component reference

3 Answers   Satyam,

suppose if u burst the reports if ur reports not reached to the destination how u will identify that one???

3 Answers   CTS, iFlex,

which type of project we r going to snowflake schema

0 Answers   IBM,

What is the difference btw reportnet - Report studio and cognos 8 - Report studio

3 Answers   Dominion,

How to maintain Query subject’s relationships between Database layer and Model Layer? For eg - if 2 DB layer's query subjects are copied in Model Layer - Query subjects respectively, then Where should we define relationship of both Query subjects? Either in DB layer or Model layer?

0 Answers  

What is a Transformer?

0 Answers  

For more Cognos Interview Questions Click Here
Categories