what is the difference btween olap and oltp?
- 6 Answers
- 15839 Views
- CTS, Fujitsu, I also Faced
- E-Mail Answers
Answer Posted / 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.
| Is This Answer Correct ? | 26 Yes | 3 No |
Post New Answer View All Answers
Explain about a tricky situation for which you found a very simple solution?
Can we Save (save as) WEBI Doc as DESKI?
How to execute the plsql procedure from the report by clicking with mouse?
What are the steps to do to use alerts in bo?
When to use local filter and when to use global filter?
what is the difference b/w the refresh and buffered data?
Explain what are the measure objects?
What is Indexing? how did u implement indexing?
Explain what would you consider as your biggest achievement and why?
Explain about alerts in bos, under what situation we need to use alerts?
What are the data types present in bo? What happens if we implement view in the designer and report?
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)?
What is difference between custom hierarchy and report based hierarchy?
Are data mart and dwh normalized or denormalized? Do both of them exist in the same tier?
What is object stores?
