what is the difference btween olap and oltp?

Answer Posted / madhusudana rao

OLAP:
# OLAP means Online Analytical Processing
# OLAP is denormalized
# it's containes current&previouse data and used for the
analytical purpose
# perfprmance processing is slow compare with OLTP
#it is used to store the large data

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

BO Security (creating the restriction sets in Universe and applying on selected groups or users) or Database security (Creating the tables in database insrting the user details in that tables and giving conditions in self restricting joins in Universe )Which Security will improve the performance of the reports and for best practices ? I am thinking BO Security will give the better performance, could you please share your thoughts on this please... Thanks...

1725


Can you please send me the migration related issues .

1650


What is the difference between condition & filter?

609


Hi friends, I am trying to create OLAP connection in IDT. I am getting error "error code:405 METHOD NOT ALLOWED" I am using "http:/olap/msmdpump.dll" I am using ms sql server 2012 -- cube

3289


Explain are data mart and data warehouse normalized or denormalized? Do both of them exist in?

606






What is report template in b.o?

588


Explain how many universes can be created in a project?

617


Give some information on report bursting and how to do it in bca as I have to split the report and send diff reports to diff people?

549


i want my connection to be dynamic. How can I make it. I mean the username and password should be dynamic. How?

1614


Explain the data types present in bo and what happens if we implement view in the designer and report?

564


Difference between zabo and webi?

638


How to create a new calendar in CMC? Can u please tell me the process to create the required calendar. Ex:- Year of that calendar to start with Jan-15 and ends with Jan -30 and the Next month to start with Feb-31 and ends with Feb-14.

1892


Hi I'm using data federator.I would like to know if it allows select statment in where clause.For example: SELECT Employee, company, orgunit FROM TAB_BIG WHERE employee IN (Select TAB_SMALL.employee FROM TAB_SMALL WHERE flag = X ) bye

1432


can anybody tell me about complicated object you have created

2755


What is thumbnail?

580