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 / anand
OLTP:--
1.Its a Two dimensional Analysis.
2.We can store the data in a limited Period.
3.Here detailed Level of information is available.
OLAT:--
1.Its a multidimensional Analysis.
2.we can store the data more than 5 years.
3.Here Summerised level of information is available.
| Is This Answer Correct ? | 4 Yes | 1 No |
Post New Answer View All Answers
Can we load the datatable directly using sql query ?
What is dbdatasource ?
can any one explain end routine...like when it is used...and give an examole.......similarly for end routine..
Hi Friends, 1) What precautions i should take as a BI Consultant when it is to UPGRADE the version of ECC (Eg: from R/3 to ECC 6.0)? 2) Will this upgradation affect BI system anyway?
what is cell formatting? and advantages?
What are the limitations of di server?
What is a/r invoice ?
What is used in sdk for developing a form ?
What are the different parts of di api ?
What are the different types of transactions supported by di api ?
hi guys, now i am working in very small company for SAP_BusinessOne...after getting 3 years of exp in this company ..can i move to LEVEL5 Big Mnc's? any chance is there? or can i change technology instead of B1?
What is difference between transfer rules and update rules?
What is the value returned when any method of a di api object executes successfully?
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 is dtw in sap business one?