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


Please Help Members By Posting Answers For Below Questions

What is a/p invoice ?

605


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?

1803


How types of reports we can create in BOBJ

2102


can any one explain end routine...like when it is used...and give an examole.......similarly for end routine..

1950


What is the function of ui api i.e. User interface api ?

635






What are the limitations of di server?

638


Why sap business one?

669


Is it possible to alter the standard behaviour of sap business one using sdk ?

591


What will happen if we remove eventfilters ?

583


What is the value returned when any method of a di api object executes successfully?

677


What is difference between matrix and grid in sap business one?

595


What is a/r invoice ?

614


What is reconcile Adjustment Account in SAP Business One

2556


Explain different parts of di api?

639


What is di server in sap business one ?

588