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
how get the grand total in master-detail report?
What is aggregate table and aggregate fact table ... Any examples of both?
what are the tables used in health care domain project and columns used in report?
How were the reports scheduled and how to resolve unexecuted documents?
Explain is data mart?
Explain what is aggregate table and aggregate fact table ... Any examples of both?
What is the difference between the public object&schema object?
is it possible to export the webi reports to crystal reports?with out using businessview?
How to create Index to the table in the universe designer and how it improves the Query performence
In source system we have os - windows BO - 5.1.5. with webi 2.7.1 Repository database - oracle Reports database - Oracle and DB2 Nearly we have 1200 reports in present system , i want to move as it is to new hardware os- windows bo- 5.1.5 with webi2.7.1 repository - oracle reports - oracle and db2 let me know is there any migration techniques in same version. thanks in advance Usha
How to Explain about BO projects in interviews?(in Banking,insurance,Manufacturing domains)
What is the difference between absolute and relative div positioning?
How to open a universe with out using the Designer ??
Explain what is the difference between slice and dice and cross tab report?
Explain what is the difference between business requirement document and use case document.