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 difference between transfer rules and update rules?
What is the value returned when any method of an di api object executes successfully ?
can any working guy help me...by explaining me about any twop reports which u have created.....on sales and purchase
Explain core modules of sap business one?
What are the different objects in di api ?
What is di server in sap business one ?
What is ‘sap business one’?
What are the functions of data interface api (di api)?
What are the limitations of di server?
What is the value returned when any method of a di api object executes successfully?
Explain different parts of di api?
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?
What is the function of ui api i.e. User interface api ?
what is cell formatting? and advantages?
If we are Extracting Data From SD Application component.ie Ex:- sales and billing 2lis_11_vahdr & 2lis_13_vdhdr Data Sources.Can I load From These 2 Data Sources to sales overview Cube 0sd_c03.Can you Explain the procedure.