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 / ashok kumar j
OLTP::
It Is Exclusively designed for Transaction purpose only,when we use this for analytical process it will have load on data base.
We can Maintain only transactional data i.e current data.
Integration across different modules is tough task.
OLAP:: It is used for analytical processing.
In This we can maintain the historical data.
Integration across different modules is easy.
Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
Can we do aggregation in sap crm planning cube?
What are the features of sap business one include?
What is ‘sap business one’?
In sap business one sdk, which object is used for executing sql queries and stored procedures ?
What is company object in sap business one ?
What are the different objects in di api ?
What is the value returned by a method when it executes successfully?
What are the benefits of sap business one?
What is the value returned when any method of an di api object executes successfully ?
what is cell formatting? and advantages?
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.
can any working guy help me...by explaining me about any twop reports which u have created.....on sales and purchase
can any one explain end routine...like when it is used...and give an examole.......similarly for end routine..
For performing heavy duty operations what is suitable di api or di server ?
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