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
- 6 Answers
- 17903 Views
- I also Faced
- E-Mail Answers
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 used in sdk for developing a form ?
What are the different types of transactions supported by di api ?
What will happen if we remove eventfilters ?
hi frnds dc's suma could u tell me. 1. expalin u have created any customize cube? 2. what is ur exp in bex and wad? 3. howmany reports u have created? give one scenario abour calculated key figure and formula? 4. tell me some recently what u have done tickets give me 2 tickets explain briefly? 5.what they (off shore team) have done ? what is cell formatting? and advantages?
Which table saves the details of country ?
What are the features of sap business one include?
What is a/r invoice ?
What is the value returned when any method of an di api object executes successfully ?
What is the difference between a client & customer in a SAP BI Project?? Is it same?
What are the functions of data interface api (di api)?
Can we load the datatable directly using sql query ?
What is difference between matrix and grid in sap business one?
What are the different objects in di api ?
What is reconcile Adjustment Account in SAP Business One
What is the function of ui api i.e. User interface api ?
