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
How types of reports we can create in BOBJ
Can we do aggregation in sap crm planning cube?
what is cell formatting? and advantages?
How is sap business one implemented ?
What is the difference between a client & customer in a SAP BI Project?? Is it same?
What is difference between ap or a/p and ar or a/r?
Which property of matrix gives the total number of rows in the matrix ?
Can sap business one be customized?
What is di server in sap business one ?
Explain different parts of di api?
What is di api in sap business one?
What is dbdatasource ?
can any one explain end routine...like when it is used...and give an examole.......similarly for end routine..
What are the different objects in di api ?
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?