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


Please Help Members By Posting Answers For Below Questions

How many universes can be created in a project?

597


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,

1583


Can anybody tell me what are the tuning problems?

1590


Difference between zabo and webi?

638


What task is 98% of the required work of a business analyst?

579






can some body explain how migrate the BoXI r2 to BO 3.x and crystal reports XI r1 to Crystal report 2008 ?

932


WHAT ARE THE META DATA TYPES?WHICH META USING IN BO'S

1691


What is thumbnail?

580


Explain is it the job of a business analyst or systems analyst to draw the class diagram?

590


Differences between business objects and web intelligence reports?

651


is it possible to export the webi reports to crystal reports?with out using businessview?

1817


what is universe null

1991


(1) Is it possible to create measures using objects from different context. (2) If cross context measures are not possible then what about @aggregate_aware() function ,here we use objects from different contexts. (3)Two measures from two different context ,can they be summed at report level.

994


Explain what is the difference between slice and dice and cross tab report?

608


What is the functional & architectural differences between business objects and web intelligence reports?

554