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
What is the use of company object in sap business one ?
What is dbdatasource ?
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?
What are the different objects in di api ?
What is the function of ui api i.e. User interface api ?
Is it possible to alter the standard behaviour of sap business one using sdk ?
What are the features of sap business one include?
What will happen if we remove eventfilters ?
What is a/p invoice ?
For performing heavy duty operations what is suitable di api or di server ?
What are the sap business one modules?
Which tool is provided by sap for keeping the track of events ?
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
can any working guy help me...by explaining me about any twop reports which u have created.....on sales and purchase
What is a/r invoice ?