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

Can anybody explain breifly about 5 tier's of BOXIR3. 1. Client tier 2. Application Tier 3. Intelligence Tier 4. Processing Tier 5. Data Tier

2 Answers  

How can we use multiple data providers in a single report in business objects?

2 Answers  

can anybody explain me in detail what is the difference between desktop intelligence and web intelligence in detail?

2 Answers  

Please Send to my e-mail Interview Questions With Answers , Technical Test Questions With Answers and Code Snippets Of Business Objects - Dev , Business Objects - Reporting Analysis .

3 Answers   AOL,

What are the difference between merge,auto merge and extended merge ?

1 Answers   Cap Gemini,

What are the join problems comes appart from loop,chasm & fan Traps

0 Answers   IBM,

How to view Public folder in Infoview for the Non-admin user? (normal user) What is the diff of working DEKI,WEBI in Infoview, and working as Individual start->Business Objects-> Deskto Intelligence, Web Intelligence.

1 Answers   Cap Gemini, TCS,

how to solve the incompatible objects and how they are formed actually.

2 Answers   CTC,

How to particiapte the columns availabe in the Derived tables in the Reporting window? How it's done?

1 Answers   WinAlliance,

Can we create universe with no cache??

0 Answers  

Explain and tell me about a situation where your analysis of a problem was deemed to be incorrect? What would you have done differently?

0 Answers  

Hi I'm using data federator.I would like to know if it allows select statment in where clause.For example: SELECT Employee, company, orgunit FROM TAB_BIG WHERE employee IN (Select TAB_SMALL.employee FROM TAB_SMALL WHERE flag = X ) bye

0 Answers