Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference btween olap and oltp?
- 6 Answers
- 17988 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 a fantrap in business objects?
WHAT ARE THE META DATA TYPES?WHICH META USING IN BO'S
explain in detail about type 3?
What are the general problems that are faced while importing the .biar files and what is the solution to overcome it in business objects?
how to create metric universe ?
Explain are data mart and dwh normalized or denormalized? Do both of them exist in the same tier?
Explain and tell me about a situation where your analysis of a problem was deemed to be incorrect? What would you have done differently?
Can Bo generates the Report from the cubical data Explain?
Explain about a task that really tested your analytical abilities?
When to use local filter and when to use global filter?
What is the difference between absolute and relative div positioning?
is it possible to export the webi reports to crystal reports?with out using businessview?
Explain is there any other repository domains rather than universe, security, document?
Explain about a time when you discovered a more efficient way to do a work task?
What is the dense rank?
