What is Molap and Rolap? What is Diff between Them?
Answer Posted / nethaji
MOLAP has aggregated value stored in cube.Since the data is
aggregated, query performance is fast.
ROLAP has data sored in relational databases.Here query has
to access the database for retrieving the data every time.So
performance is slow when compared to molap. Size is larger
than molap.
Is This Answer Correct ? | 7 Yes | 0 No |
Post New Answer View All Answers
What are the different problems that ?Data mining? can solve?
what are relationships?
What is the difference between view materialized view and view?
What are the various methods of getting incremental records or delta records from the source systems?
Difference between cold fusion 5 and cold fusion mx 6?
Explain ddl (data definition language)?
Explain differences between star and snowflake schemas?
Hyperion is the one of the tool in data ware house. Its an olap tool. Why you cant display that tool?
What is your spectra photometer working principles?
Explain techniques of error handling - ignore , rejecting bad records to a flat file , loading the records and reviewing them (default values)?
After we create a scd table, can we use that particular dimension as a dimension table for star schema?
Hi, i want to do certification in datawarehouse?? which certification is best in current trend?? pls mention the cost also if u can....
What is surrogate key? Explain with examples.
What is hybrid slowly changing dimension?
Explain clustering algorithm?