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

What are the functions of data interface api (di api)?

737


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

3621


Explain different parts of di api?

786


What is di api in sap business one?

728


What is the function of observerdll.dll ?

939






Hi everybody, This is Srinu,recently i got selected for a small comapny with sap b1 but i was new to the technology.I knew c#.net,asp.net,Sql server 2005.My question is what are the pre-required knowledge to learn SAP B1 please suggest me. Thanks & Regards.

1629


What is di server in sap business one ?

749


Explain core modules of sap business one?

686


Why sap business one?

806


Can sap business one be customized?

762


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

704


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

757


What is dbdatasource ?

1048


How is sap business one implemented ?

747


What is difference between transfer rules and update rules?

1697