Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference btween olap and oltp?
- 6 Answers
- 18200 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
is it possible to export the webi reports to crystal reports?with out using businessview?
Are data mart and dwh normalized or denormalized? Do both of them exist in the same tier?
What is a fantrap in business objects?
What is the difference between user and versatile user?
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's the Functional & Architectural Differences between Business Objects & Web Intelligence Reports?
Can we create universe with no cache??
Give some information on report bursting and how to do it in bca as I have to split the report and send diff reports to diff people?
Can more than 1 metric be applied on an analytic in business objects?
Can any one say me how i can integrate 3 or more analytics like radio bottons,line chart,pie chart while designing a dash board in xcelsius and i am also facing problem to show one after another values in the same chat at a time..... Please help me out for this....
how to prepare the documentation in business objects and where to get the requirement?
What if a cartesian product pop up block appears when running a report. Does it give wrong values? How to solve this issue?
Explain in detail about type 2(scd),
can anybody tell me about complicated object you have created
How to sort the dynamic objects alphabetically on the Universe based on and SQL Server
