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 / hema

oltp -- example for oltp is sap r/3.it is optimised by
data storage.read,write access is possible.contains limited
historical data.data base size is finite.

olap--- example for olap is sap bw/bi.It is optimised by
reporting.Only read access is possible.Contains lots of
historical data.Data base size in infinite

Is This Answer Correct ?    17 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

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

621


What is the use of company object in sap business one ?

605


What are the different types of transactions supported by di api ?

766


What is the value returned when any method of an di api object executes successfully ?

569


What are the benefits of sap business one?

594






Why sap business one?

681


What is the value returned by a method when it executes successfully?

606


Which table saves the details of country ?

587


What is the function of observerdll.dll ?

809


Is it possible to alter the standard behaviour of sap business one using sdk ?

599


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

613


What is di api in sap business one?

607


What are the different types of datasources ?

609


How to fill data in recordset ?

697


Which are the dll’s used in sap business one sdk?

627