When we go for OLAP , and When we go for OLTP for
generating the reports ?
Answer Posted / kkreddy
When we need more historical data we will opt for OLAP. And
when we need the real time data or current data we will opt
for OLTP.
| Is This Answer Correct ? | 8 Yes | 1 No |
Post New Answer View All Answers
How to execute the plsql procedure from the report by clicking with mouse?
What is thumbnail?
How to do impact analysis for a change in Database field size which is assigned to a Dimension object and used in 10 universes
What is the difference between datawarehousing and businessintelligence?
Explain are data mart and dwh normalized or denormalized? Do both of them exist in the same tier?
What Is The Difference Between Oltp And Olap?
What are the general problems that are faced while importing the .biar files and what is the solution to overcome it in business objects?
Explain is there any tool that can compare two unvs / two rpts , built using bo 5.1 / bo 6.5?
What are the join problems comes appart from loop,chasm & fan Traps
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)?
any difficulitis have you phase while creating bo reports and how did u solve it
What's the Functional & Architectural Differences between Business Objects & Web Intelligence Reports?
What is top business?
Explain and tell me about a situation where your analysis of a problem was deemed to be incorrect? What would you have done differently?
How to sort the dynamic objects alphabetically on the Universe based on and SQL Server