What is Molap and Rolap? What is Diff between Them?
Answer Posted / marcelo malheiros
I believe you lost the begining of my answer...
"I know a lot of people understand ROLAP and MOLAP as where
the information is stored: if data is in a RDBMS, is ROLAP;
if it is in a self-contained cube, it is MOLAP.
I find the above a misconcept of the terms."
Let me repeat the fundamental question: How would classify
On Line Analytical Process performed on top of IMS, IDMS,
ADABAS, VSAM, flat file, XML and other non RDBMS data
storages?"
Is This Answer Correct ? | 0 Yes | 2 No |
Post New Answer View All Answers
Explain techniques of error handling - ignore , rejecting bad records to a flat file , loading the records and reviewing them (default values)?
What is a real-time data warehouse? How is it different from near to real-time data warehouse?
What is the difference between connected and unconnected stored procedures?
How can we do data cleaning?
Explain what is difference between query studio and report studio?
Explain what are the various reporting tools in the market?
What is the main difference between inmon and kimball philosophies of data warehousing?
Explain what is the difference between olap and datawarehosue?
what is parallel query?
How would you write a simple stored procedure in tsql which takes a movie_id and returns all the directors associated with it?
What is ods (operation data source)?
What is a Decision Tree Algorithm?
Explain what type of indexing mechanism do we need to use for a typical datawarehouse?
What is edw?
Explain the definition of normalized and denormalized view?