----------------------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
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 r the migration tools available in the market with respect to cognos such as impromptu reports are migrated to cognos reportnet??
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
What are shortcuts? Where it can be used? What are the advantages?
what is your project workflow and your role in the project?
How can I disable the drill-down for the last level of my dimensional hierarchy ????
how to create measures and dimensions?
whis meant by Thumbnails on cagnos?
Write a SQL query which should fetch the 5th maximum salary of an employee from the table?
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 ?
What is Cognos Powerhouse and what is it used for?
What is difference between page break and section report?
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?