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 / praneeth
OLTP
IT is a two dimensional table included with ER-model(entity relationship model).here we can analyse only two dimensions.
OLAP
It is a multi-dimensional table included with 4 schemas i.e,
star schema, extended star schema, snow flake and highbrid.
In bi we can use extended star schema.
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
What are the benefits of sap business one?
What are the functions of data interface api (di api)?
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?
What are the different types of datasources ?
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 ?
can any one explain end routine...like when it is used...and give an examole.......similarly for end routine..
What is the function of observerdll.dll ?
For performing heavy duty operations what is suitable di api or di server ?
What is di server in sap business one ?
What will happen if we remove eventfilters ?
What is the value returned by a method when it executes successfully?
What are the sap business one modules?
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?