Can anybody explain the what is "OLTP"(Online Transaction
Processing) and "OLAP"(Online Abaytical Processing) in SAP
BW/BI? and also plz explain What is the differences between
those two?


Thanks in advance,
Phani

Answer Posted / sadaddin

OLAP(online Transaction processing):
It contains the current data.Any system Supports INSERT,DELETE,UPDATE & SELECT operations is also known as OLTP.Because of "Update" & "DELETE" statements it contains Current data.

OLTP(online Analyitical Processing):Report to Report comparision is called Analysis.Data WArehouse contains current data+ historical data for Analysis is named as OLAP

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is used in sdk for developing a form ?

572


Explain different parts of di api?

639


What are the complex reports you developed in Business Objects.Please tell me 3 reports you developed and the complexity you faced and the solution

4686


What are the different objects in di api ?

573


What is the function of ui api i.e. User interface api ?

635






Where does di server executes i.e. Client or server ?

603


What is a/r invoice ?

614


What are the different components of sap business one client software ?

618


What is company object in sap business one ?

595


Can we do aggregation in sap crm planning cube?

2388


hi guys, now i am working in very small company for SAP_BusinessOne...after getting 3 years of exp in this company ..can i move to LEVEL5 Big Mnc's? any chance is there? or can i change technology instead of B1?

1803


Which tool is provided by sap for keeping the track of events ?

608


What is di server in sap business one ?

588


Can we load the datatable directly using sql query ?

663


What are the benefits of sap business one?

586