what is materialised view? why we use it in data warehousing?

Answer Posted / suman palisetty

Materialized Views are objects which have information that has been aggregated and summarized from source tables.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What do you understand by the term 'aggregate advisor?'

541


What are initial page components of Cognos connection?

617


What is the difference between Standard and Metrics folder?

577


What do you mean by drill through report?

582


how many numbers of cubes can we create on a single model? How can we navigate between those cubes?

597






What is looping and how to avoid it in framework manager?

675


Can you define cube?

597


Is it possible to join multiple Databases in a Catalog?

650


In my report i want display sales rep name, country ,city how to achieve this by using repeater table

1538


please please give me some banking calculations in framework manager.

1667


i have taken quantity on ANx-axis & months on y-axis(months r not in oreder )when i run the reoprt i need months in proper order .how can i do this ?

1566


-------------How you design DWH?

1898


what are the components in the cognos connection page consists (eg: my folder, public folder,directions, schedule management tool etc.....)

1709


Explain what is the difference between microstrategy and cognos reporting tool?

551


How to test a cube?

1686