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 different types of datasources ?

595


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

592


What are the limitations of di server?

636


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?

3496


Explain different parts of di api?

631






What are the different objects in di api ?

571


What is di api in sap business one?

585


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

586


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

673


can any one explain end routine...like when it is used...and give an examole.......similarly for end routine..

1942


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

746


How is sap business one implemented ?

586


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.

1477


What is used in sdk for developing a form ?

569


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

578