Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 19234 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 difference between transfer rules and update rules?
What are the functions of data interface api (di api)?
What are the benefits of sap business one?
What will happen if we remove eventfilters ?
Hi Friends, 1) What precautions i should take as a BI Consultant when it is to UPGRADE the version of ECC (Eg: from R/3 to ECC 6.0)? 2) Will this upgradation affect BI system anyway?
Can sap business one be customized?
Can we load the datatable directly using sql query ?
What are the complex reports you developed in Business Objects.Please tell me 3 reports you developed and the complexity you faced and the solution
What is used in sdk for developing a form ?
What are the different objects in di api ?
What is the value returned by a method when it executes successfully?
Why sap business one?
What is the function of ui api i.e. User interface api ?
Explain different parts of di api?
what is cell formatting? and advantages?
