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
What is company object in sap business one ?
What is used in sdk for developing a form ?
How types of reports we can create in BOBJ
What is difference between ap or a/p and ar or a/r?
What is di server in sap business one ?
What is dtw in sap business one?
What is the function of ui api i.e. User interface api ?
What are the different parts of di api ?
In sap business one sdk, which object is used for executing sql queries and stored procedures ?
can any working guy help me...by explaining me about any twop reports which u have created.....on sales and purchase
What will happen if we remove eventfilters ?
What are the different types of datasources ?
What is the function of observerdll.dll ?
Hi Friends, 1) What precautions i should take as a BI Consultant when it is to UPGRADE the version of ECC (Eg: from R/3 to ECC 6.0)? 2) Will this upgradation affect BI system anyway?
Which table saves the details of country ?