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
- 6 Answers
- 17770 Views
- I also Faced
- E-Mail Answers
Answer Posted / sadaddin
OLAP(online Transaction processing):
It contains the current data.Any system Supports INSERT,DELETE,UPDATE & SELECT operations is also known as OLTP.Because of "Update" & "DELETE" statements it contains Current data.
OLTP(online Analyitical Processing):Report to Report comparision is called Analysis.Data WArehouse contains current data+ historical data for Analysis is named as OLAP
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What are the different objects in di api ?
For performing heavy duty operations what is suitable di api or di server ?
What is the value returned by a method when it executes successfully?
Which property of matrix gives the total number of rows in the matrix ?
What are the different components of sap business one client software ?
hi frnds dc's suma could u tell me. 1. expalin u have created any customize cube? 2. what is ur exp in bex and wad? 3. howmany reports u have created? give one scenario abour calculated key figure and formula? 4. tell me some recently what u have done tickets give me 2 tickets explain briefly? 5.what they (off shore team) have done ? what is cell formatting? and advantages?
Can we load the datatable directly using sql query ?
What are the features of sap business one include?
What is the difference between a client & customer in a SAP BI Project?? Is it same?
What is reconcile Adjustment Account in SAP Business One
How to fill data in recordset ?
Which are the dll’s used in sap business one sdk?
Can sap business one be customized?
Can we do aggregation in sap crm planning cube?
What is a/r invoice ?
