Interested to Buy Any Domain ? << Click Here >> for more details...
----------------------Diff b/w MOLAP and ROLAP?
- 4 Answers
- 7449 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 many reports do u create in ur project?i don't have real time exp..tell me based on ur exp..for interview pt of view,don't say it depends on ur project and u? thanks in advance..
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?
What are all the types of indexes in Cognos?
how can you create a project creation
1)How can we do the Union in Report Studio? 2)What is the meaning of Aggregation and Rollup Aggregation? 3)How can we hide the columns in Report Studio and How can we view the hiding Objects? 4)Can we provide joins in Report Studio and in which situation we can go for outer join? 5)If we take a Date Prompt and run it once it will show default data,how can we change it exact 1 month back data?
Where do i get Cognos 10 BI Online Training in Low price for the below tools. Cognos Framework Manager Cognos Report Studio Cognos Query Studio Cognos Analysis Studio Cognos Event Studio Cognos Transformer Cognos TM1 Development
How to write the necessary TSQL to create data sets, pull the data sets in Cognos Report Studio WITHOUT using framework manager.
1. Explain your project.
What is the importance of having monitor service in cognos?
What do you mean by query studio?
Can you define transformer?
----------------What is Surrogate Key?
Teradata 
