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

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

2265


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

688


what is cell formatting? and advantages?

4324


Why sap business one?

768


Can we load the datatable directly using sql query ?

775






Which table saves the details of country ?

659


Can sap business one be customized?

698


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.

1575


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

686


What is a/r invoice ?

707


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

684


What are the features of sap business one include?

632


Explain core modules of sap business one?

641


If we are Extracting Data From SD Application component.ie Ex:- sales and billing 2lis_11_vahdr & 2lis_13_vdhdr Data Sources.Can I load From These 2 Data Sources to sales overview Cube 0sd_c03.Can you Explain the procedure.

3113


What are the different types of datasources ?

679