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
Explain about a task that really tested your analytical abilities?
What is object stores?
How to do impact analysis for a change in Database field size which is assigned to a Dimension object and used in 10 universes
Explain about alerts in bos, under what situation we need to use alerts?
How to open a universe with out using the Designer ??
Can we Save (save as) WEBI Doc as DESKI?
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 the general problems that are faced while importing the .biar files and what is the solution to overcome it in business objects?
U r project in which stage in implementation?
When we use aggregate awareness function in designer?
what is xcelsius architecture?
What Is Snow Flake Schema?
What is the difference between business requirement document and use case document.
Explain what is aggregate table and aggregate fact table ... Any examples of both?
Explain what task is 98% of the required work of a business analyst?