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
What is object stores?
What if a cartesian product pop up block appears when running a report. Does it give wrong values? How to solve this issue?
What is the functional & architectural differences between business objects and web intelligence reports?
Explain which versions are used in the bo dashboard work?
If I have three predefined prompts. In a report it will come randomly. How they will come in a specified format?
is it possible to export the webi reports to crystal reports?with out using businessview?
how to create metric universe ?
Explain the data types present in bo and what happens if we implement view in the designer and report?
any difficulitis have you phase while creating bo reports and how did u solve it
Explain the difference between detect alias and detect context?
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
Explain what is the difference between slice and dice and cross tab report?
i want my connection to be dynamic. How can I make it. I mean the username and password should be dynamic. How?
Explain the difference between union and group?
Explain how can we do load testing for webi reports? (Example if I have have to test one webi report for concurrent users refreshing report at one time)?