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 / ashok kumar j
OLTP::
It Is Exclusively designed for Transaction purpose only,when we use this for analytical process it will have load on data base.
We can Maintain only transactional data i.e current data.
Integration across different modules is tough task.
OLAP:: It is used for analytical processing.
In This we can maintain the historical data.
Integration across different modules is easy.
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
In sap business one sdk, which object is used for executing sql queries and stored procedures ?
What is the value returned when any method of a di api object executes successfully?
What is the function of ui api i.e. User interface api ?
Explain core modules of sap business one?
Where does di server executes i.e. Client or server ?
What are the different components of sap business one client software ?
What is di api in sap business one?
What is a/r invoice ?
How is sap business one implemented ?
What is difference between ap or a/p and ar or a/r?
Which property of matrix gives the total number of rows in the matrix ?
What is company object in sap business one ?
What is the use of company object in sap business one ?
What is dtw in sap business one?
What is the function of observerdll.dll ?