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 ?

769


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

1926


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

776


Explain different parts of di api?

822


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

745






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

3663


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

2140


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

800


Which property of matrix gives the total number of rows in the matrix ?

770


What is difference between transfer rules and update rules?

1735


my name is sandeep i want to join SAP Bi/BO hyd. can anyone suggest best institue or tranier with material also .sucess rate of them should be very good.. bcoz its very hard select insistiue in ameerpet...one and other all are same many people are misguided.. failling in interviews...if any one know please help answer this question so this will help others also

2365


How types of reports we can create in BOBJ

2275


What are the sap business one modules?

782


What are the different objects in di api ?

744


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

793