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 / 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 the value returned when any method of an di api object executes successfully ?
What is the value returned when any method of a di api object executes successfully?
Which are the dll’s used in sap business one sdk?
What is a/r invoice ?
Hi everybody, This is Srinu,recently i got selected for a small comapny with sap b1 but i was new to the technology.I knew c#.net,asp.net,Sql server 2005.My question is what are the pre-required knowledge to learn SAP B1 please suggest me. Thanks & Regards.
What are the functions of data interface api (di api)?
Which property of matrix gives the total number of rows in the matrix ?
What is difference between transfer rules and update rules?
What is the function of observerdll.dll ?
What is company object in sap business one ?
For performing heavy duty operations what is suitable di api or di server ?
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 parts of di api ?
What is the function of ui api i.e. User interface api ?
What is used in sdk for developing a form ?