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 / hema
oltp -- example for oltp is sap r/3.it is optimised by
data storage.read,write access is possible.contains limited
historical data.data base size is finite.
olap--- example for olap is sap bw/bi.It is optimised by
reporting.Only read access is possible.Contains lots of
historical data.Data base size in infinite
| Is This Answer Correct ? | 17 Yes | 2 No |
Post New Answer View All Answers
What is ‘sap business one’?
What are the different components of sap business one client software ?
What is reconcile Adjustment Account in SAP Business One
In sap business one sdk, which object is used for executing sql queries and stored procedures ?
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 are the limitations of di server?
What is difference between matrix and grid in sap business one?
Is it possible to alter the standard behaviour of sap business one using sdk ?
Which table saves the details of country ?
What is dbdatasource ?
Which property of matrix gives the total number of rows in the matrix ?
What is the difference between a client & customer in a SAP BI Project?? Is it same?
Which tool is provided by sap for keeping the track of events ?
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 cell formatting? and advantages?