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
Which property of matrix gives the total number of rows in the matrix ?
In sap business one sdk, which object is used for executing sql queries and stored procedures ?
What are the limitations of di server?
What is difference between transfer rules and update rules?
Can sap business one be customized?
What will happen if we remove eventfilters ?
How types of reports we can create in BOBJ
Where does di server executes i.e. Client or server ?
What is ‘sap business one’?
What are the different types of datasources ?
Which table saves the details of country ?
What is the function of observerdll.dll ?
What are the functions of data interface api (di api)?
Which tool is provided by sap for keeping the track of events ?
What are the different objects in di api ?