what is the difference btween olap and oltp?
Answer Posted / madhusudana rao
OLAP:
# OLAP means Online Analytical Processing
# OLAP is denormalized
# it's containes current&previouse data and used for the
analytical purpose
# perfprmance processing is slow compare with OLTP
#it is used to store the large data
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
is it possible to export the webi reports to crystal reports?with out using businessview?
Explain what would you consider as your biggest achievement and why?
When to use local filter and when to use global filter?
I have 2 doubts regarding the "Input Control" functionality in BI4: 1) Can the Input Controls in BI4 be manipulated? I mean, can we change the IC display as BOLD or change the values from Italics to regular? Or change the colors? 2) How to get hierarchy type control in IC? Let's say my first IC is for Country and second is for State. If I select a particulat country from Ist IC,second one should show me states belonging to selected country. Is that possible? Thanks in advance!!!
What are all difference between business objects 6.5 and xi r2?
Explain is there any tool that can compare two unvs / two rpts , built using bo 5.1 / bo 6.5?
Are data mart and dwh normalized or denormalized? Do both of them exist in the same tier?
How much data hold in one universe 336 can any one explain about core dimension, balanced dimension, and dirty dimension?
What are the data types present in bo? What happens if we implement view in the designer and report?
What Is The Difference Between Oltp And Olap?
What is the difference between the public object&schema object?
What is package in BO
Can we Save (save as) WEBI Doc as DESKI?
Can I create a master report in webi having 15 dimensions and 150 kpi's with 100GB of data and store it in cache ,So that I can use Cache for building new reports with less dimensions and Kpi's without hitting database againg just using cache??Please suggest...
Can more than 1 metric be applied on an analytic in business objects?