what is the difference btween olap and oltp?
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
How to open a universe with out using the Designer ??
How to Explain about BO projects in interviews?(in Banking,insurance,Manufacturing domains)
1. 101 vinay hyderabad 123 naresh usa 152 singh delhi 101 vinay usa 123 naresh mumbai 156 raju chennai From the above data we need to retrive current data in a report ? how and explain in detail ?
Hi, I would like to know how is the integration if we want to use Oracle Essbase as the Cube Engine, and present the Cube by Business Objects Presentation Layer? Can Oracle Essbase be integrated with Business Objects? Thanks,
How were the reports scheduled and how to resolve unexecuted documents?
What is the difference between condition & filter?
What is the profile and package?
Is there any other repository domains rather than universe, security, document?
What is difference between custom hierarchy and report based hierarchy?
hi all of u, i want to learn the course in SAP(BI).because of there is no calls for BO. And the another region is it will be converted into SAP module. is it OK for me? is there any feauture in coming days? could any one plz send me the message
Explain as a ba (business analyst) approaching a new piece of work, who would you interview and what questions would you ask?
Explain 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 difference b/w the refresh and buffered data?
how get the grand total in master-detail report?
Differences between business objects and web intelligence reports?