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 / anand

OLTP:--
1.Its a Two dimensional Analysis.
2.We can store the data in a limited Period.
3.Here detailed Level of information is available.

OLAT:--
1.Its a multidimensional Analysis.
2.we can store the data more than 5 years.
3.Here Summerised level of information is available.

Is This Answer Correct ?    4 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Can we do aggregation in sap crm planning cube?

2574


Why sap business one?

832


Which are the dll’s used in sap business one sdk?

799


Explain different parts of di api?

822


What is di server in sap business one ?

781






What is the use of company object in sap business one ?

781


Explain core modules of sap business one?

716


How to fill data in recordset ?

883


What is the value returned by a method when it executes successfully?

793


my name is sandeep i want to join SAP Bi/BO hyd. can anyone suggest best institue or tranier with material also .sucess rate of them should be very good.. bcoz its very hard select insistiue in ameerpet...one and other all are same many people are misguided.. failling in interviews...if any one know please help answer this question so this will help others also

2365


What are the limitations of di server?

822


What is di api in sap business one?

759


What will happen if we remove eventfilters ?

811


For performing heavy duty operations what is suitable di api or di server ?

800


What is company object in sap business one ?

747