what is the difference btween olap and oltp?
- 6 Answers
- 16299 Views
- CTS, Fujitsu, I also Faced
- E-Mail Answers
Answer Posted / 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
| Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
what is xcelsius architecture?
What are the steps to do to use alerts in bo?
What is report template in b.o?
Can more than 1 metric be applied on an analytic in business objects?
Explain what three things do you consider to be the most important factors for a manager?
Explain about a task that really tested your analytical abilities?
What is a fantrap in business objects?
how many reports have u created ? explain a few.
Explain what is the difference between business requirement document and use case document.
If 2 tables are joined by Shortcut join, if query is generated based these join, what will be the join type and what will be the generated query? Thanks in advance?
If there are no indices defined on any of the columns in the above two tables, which columns would you index to speed up the left join query?
what is the difference between add link and include link in BO? Explain me with a scenario when to go for add link and when to go for include link?
Is there any other repository domains rather than universe, security, document?
How to execute the plsql procedure from the report by clicking with mouse?
What is the difference between slice and dice and cross tab report?
