Answer / anand

OLTP
* Is the E-R modleling,there are more concurrent users,
* It contains normalized tables so there is no redundancy.
* More tables,Joins and less Indexes,
* It stores daily transactional data
* It stores very less data
* It contains mainly current data
* INSERT,UPDATE,MODIFY can be applied on OLTP.
* Performace will be high

OLAP
* It is the Dimensional Modeling
* It contains Denormalised tables there will be redundancy.
* Less tables,Joins and more Indexes
* It stores operational data
* It contains Historical and Present data
* only SELECT clause is applied on OLAP
* It stores very Huge data
* Performance will be low compared with OLTP

Answer / jansi

OLAP - Online Analytical Processing, which deals with
analysis of data. It has to deal with historical data too (
for analysis purpose) Not updated frequently. If required
bulk update is allowed.

OLTP - Online Transactional Processing, which deals with
transactions. For e.g. withdrawals at ATM machines. It
involves many transactions. The databases have to be updated
more frequently after the successful completion of a
transaction.

Answer / vams_gk

i am agree with the above answer.olap is denormalized and
oltp normalised

Answer / balaji

OLTP

• Current data
• Short database transactions
• Online update/insert/delete
• Normalization is promoted
• High volume transactions
• Transaction recovery is necessary
• only one record is processed at a time
• data is present in 2d format

OLAP
•
• Current and historical data
• Long database transactions
• Batch update/insert/delete
• Denormalization is promoted
• Low volume transactions
• Transaction recovery is not necessary
• group of records processed at a time
• data is present in multi dim format

Answer / madhusudana rao

OLTP:
# OLTP means Online Transactional Processing, data comes
from different sources
# OLTP is normalized(3NF)
# it's used to stored the current transactional data
# it's store the less no of data
# here we will perform the DML operations
(INSERT,UPDATE,DELETE)
# performance is very fast

Answer / madhusudana rao

OLAP:
# OLAP means Online Analytical Processing
# OLAP is denormalized
# it's containes current&previouse data and used for the
analytical purpose
# perfprmance processing is slow compare with OLTP
#it is used to store the large data

how to test the reports if there are multiple sql statements?i,e if there is 1 single sql statement we can copy it and paste it in TOAD or someother tools to test it but if we have multiple sql statements in a single query????

1 Answers   IBM,

Explain difference between zabo and webi?

0 Answers  

Explain which versions are used in the bo dashboard work?

0 Answers  

How can you first report in Business Objects by using broadcast agent?

0 Answers   Ness Technologies, Wipro,

i want to use prompt for select the country names. eg, india. japan. america. like that. which delimeter is used for to seperate the countries?

5 Answers   TCS,

please explain me with the real time tables on how aggregate tables are created and how aggregate awareness is addressed to it.

0 Answers   CTC,

Analysis in business objects?

4 Answers  

in sap bi we have wad, then why we go for sap bo

0 Answers  

Hi frns, In the report level i have dragged objects in the query panel. If i check the sql query it is displaying 2 separate queries. What will be the possibilities for this?

2 Answers   Accenture,

how to test reports in businessobjects?

8 Answers   TCS,

what are the types of universes? what is the difference between metri universe and simple universe? in what context we use metric universe?

4 Answers   Fujitsu, Virtusa,

how can u find the granularity in fact table

1 Answers   iGate,