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 is a/p invoice ?
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?
How types of reports we can create in BOBJ
can any one explain end routine...like when it is used...and give an examole.......similarly for end routine..
What is the function of ui api i.e. User interface api ?
What are the limitations of di server?
Why sap business one?
Is it possible to alter the standard behaviour of sap business one using sdk ?
What will happen if we remove eventfilters ?
What is the value returned when any method of a di api object executes successfully?
What is difference between matrix and grid in sap business one?
What is a/r invoice ?
What is reconcile Adjustment Account in SAP Business One
Explain different parts of di api?
What is di server in sap business one ?