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 are the functions of data interface api (di api)?
What are the benefits of sap business one?
For performing heavy duty operations what is suitable di api or di server ?
How types of reports we can create in BOBJ
Can we do aggregation in sap crm planning cube?
What is the value returned when any method of a di api object executes successfully?
What are the different types of datasources ?
Hi everybody, This is Srinu,recently i got selected for a small comapny with sap b1 but i was new to the technology.I knew c#.net,asp.net,Sql server 2005.My question is what are the pre-required knowledge to learn SAP B1 please suggest me. Thanks & Regards.
Explain different parts of di api?
Is it possible to alter the standard behaviour of sap business one using sdk ?
Explain core modules of sap business one?
What is reconcile Adjustment Account in SAP Business One
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?
What are the sap business one modules?
Which table saves the details of country ?