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
What is the use of source qualifier?
Tell me any other tools for scheduling purpose other than workflow manager pmcmd?
How might you approve all mappings in the archive all the while?
can anyone suggest best free Talend data integration training online
what are the different types of transformation available in informatica. And what are the mostly used ones among them?
How to use procedural logic inside infromatica?
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
What are the different transaction levels available in transaction control transformation?
draw informatica architecture 8.6 ?
Write the advantages of partitioning a session?
Partition, what happens if the specified key range is shorter and longer
Is stop and abort are same in informatica?
How is union transformation utilized?
how many types of dimensions are available in informatica?
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?