what is the difference btween olap and oltp?

Answer Posted / 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

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What's the Functional & Architectural Differences between Business Objects & Web Intelligence Reports?

1624


webI report not showing Barcode in PDF format, i have used BC39 font,but barcode is shown in HTML but not in PDF, please any solutions??

3928


What is Indexing? how did u implement indexing?

1820


CAN ANY BODY PROVIDE DESCRIPTION OF ONE COMPLEX UNIVERSE AND ONE COMPLEX REPORT IN BOS 6.5 TO SRINIVASBO@YAHOO.CO.IN

1750


i want my connection to be dynamic. How can I make it. I mean the username and password should be dynamic. How?

1615






What is the difference between slice and dice and cross tab report?

608


How to execute the plsql procedure from the report by clicking with mouse?

621


How to create Index to the table in the universe designer and how it improves the Query performence

2125


What is the difference between absolute and relative div positioning?

587


What is the profile and package?

1768


How to restrict password to a user while sending a document in .pdf format

1866


Hi, What is the best answer for tell me about yourself for 2 years experience in bo developing.

3848


what is document design in boxi,have u participate in that

1663


How would you format some text using css to be verdana and bold?

675


Can we Save (save as) WEBI Doc as DESKI?

7080