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

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

1765


What will happen if we remove eventfilters ?

590


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

622


What are the benefits of sap business one?

594


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

2173






In sap business one sdk, which object is used for executing sql queries and stored procedures ?

572


Can we do aggregation in sap crm planning cube?

2400


hi guys, now i am working in very small company for SAP_BusinessOne...after getting 3 years of exp in this company ..can i move to LEVEL5 Big Mnc's? any chance is there? or can i change technology instead of B1?

1810


What are the features of sap business one include?

552


What are the complex reports you developed in Business Objects.Please tell me 3 reports you developed and the complexity you faced and the solution

4697


What is dtw in sap business one?

654


What are the different components of sap business one client software ?

629


What are the limitations of di server?

645


What is the function of ui api i.e. User interface api ?

641


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

604