----------------------Diff b/w MOLAP and ROLAP?
Answer Posted / 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 |
Post New Answer View All Answers
What is zero-foot print?
-----------Diff b/w OLAP and RDBMS?
what is the difference between filter and condition?
How do you call a store procedure within a transformation?
What are the other methods working as deployment functionality?
How security is concerned with Reportnet? Explain its implementing steps.
----------------Diff b/w Dimensional modeling and Relational modeling?
Can you define a query subject?
How create measures and dimensions?
hi..i'm searching on cognos.i want to know some real time explanation..persons who have real time exp and who r searching in this field..can u send ur mail-id..my mail-id is dhaanuus@gmail.com..hope u will respond as soon as possible..
--------------Diff b/w ODS and OLAP?
What is metric store database?
Define query items?
Define dimensions?
What is main advantage datawarehousing over oracle?