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 a rank transform?
waht type of interface is used for testing the data in informatica
What are the different transaction levels available in transaction control transformation?
What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?
How will the document be delivered to me?
Slowly changing dimensions, types and where will you use them
What is a difference between complete, stop and abort?
What is the difference between Active and Passive transformation?
is it possible to index the data in cache of lkp transformation ?
What is source qualifier transformation in informatica?
How many ways a relational source definition can be updated and what are they?
Can we override a native sql query within informatica?
What is the need of an ETL tool?
suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do
can anyone suggest best free Talend data integration training online