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
- 17502 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 is difference between ap or a/p and ar or a/r?
What is the difference between a client & customer in a SAP BI Project?? Is it same?
Which property of matrix gives the total number of rows in the matrix ?
What is di server in sap business one ?
What are the sap business one modules?
What are the features of sap business one include?
What is used in sdk for developing a form ?
What is the value returned when any method of a di api object executes successfully?
What are the different components of sap business one client software ?
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 the function of ui api i.e. User interface api ?
What are the different parts of di api ?
Explain different parts of di api?
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?
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.
