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 / ashok kumar j
OLTP::
It Is Exclusively designed for Transaction purpose only,when we use this for analytical process it will have load on data base.
We can Maintain only transactional data i.e current data.
Integration across different modules is tough task.
OLAP:: It is used for analytical processing.
In This we can maintain the historical data.
Integration across different modules is easy.
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
What is the value returned by a method when it executes successfully?
What is the difference between a client & customer in a SAP BI Project?? Is it same?
What are the different components of sap business one client software ?
What is difference between ap or a/p and ar or a/r?
What is ‘sap business one’?
what is cell formatting? and advantages?
What is dbdatasource ?
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 company object in sap business one ?
What is the value returned when any method of an di api object executes successfully ?
For performing heavy duty operations what is suitable di api or di server ?
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 sap business one modules?
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 is di api in sap business one?