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 any working guy help me...by explaining me about any twop reports which u have created.....on sales and purchase
Can we load the datatable directly using sql query ?
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
What is difference between transfer rules and update rules?
Is it possible to alter the standard behaviour of sap business one using sdk ?
What is a/r invoice ?
How is sap business one implemented ?
Why sap business one?
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.
What are the different objects in di api ?
What is a/p invoice ?
Can we do aggregation in sap crm planning cube?
What will happen if we remove eventfilters ?
What is used in sdk for developing a form ?
Can sap business one be customized?