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


Please Help Members By Posting Answers For Below Questions

How is sap business one implemented ?

785


What are the benefits of sap business one?

765


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

4879


What is a/r invoice ?

790


What is used in sdk for developing a form ?

732






In sap business one sdk, which object is used for executing sql queries and stored procedures ?

751


Explain different parts of di api?

822


What are the limitations of di server?

821


what is cell formatting? and advantages?

4407


For performing heavy duty operations what is suitable di api or di server ?

800


Can sap business one be customized?

791


What are the sap business one modules?

782


What is ‘sap business one’?

835


can any working guy help me...by explaining me about any twop reports which u have created.....on sales and purchase

1926


What is the difference between a client & customer in a SAP BI Project?? Is it same?

3663