Whatis the difference between View and Materialized View ?

Answer Posted / anju

A materialized view is a stored summary containing pre-
computed results.As the data is pre-computed, materialized
views allow for faster query answers

In warehousing applications, large amounts of data are
processed and similar queries are frequently repeated. If
these queries are pre-computed and the results stored in
the data warehouse as a materialized view, using
materialized views significantly improves performance
by providing fast lookups into the set of results.

A Materialized View generally behaves like a Index and it
can also have any Number of Aggregates and Joins.

Is This Answer Correct ?    37 Yes 6 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the use of source qualifier?

904


Tell me any other tools for scheduling purpose other than workflow manager pmcmd?

1072


How might you approve all mappings in the archive all the while?

832


can anyone suggest best free Talend data integration training online

1498


what are the different types of transformation available in informatica. And what are the mostly used ones among them?

751


How to use procedural logic inside infromatica?

888


Hi all , I am planning for informatica S - PowerCenter 8 Mapping Design certification. I have rewuired the dumps for the same. if anyone of you having the same pl. share it with me. This will be of great help. My contact is : sagardev7@gmail.com TIA , Sagar

2533


What are the different transaction levels available in transaction control transformation?

934


draw informatica architecture 8.6 ?

3670


Write the advantages of partitioning a session?

1024


Partition, what happens if the specified key range is shorter and longer

2245


Is stop and abort are same in informatica?

789


How is union transformation utilized?

806


how many types of dimensions are available in informatica?

773


Informatica Server and Client are in different machines. You run a session from the server manager by specifying the source and target databases. It displays an error. You are confident that everything is correct. Then why it is displaying the error?

1807