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

Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?

919


can we override a native sql query within informatica? Where do we do it? How do we do it?

841


How do you manage the Parameter files while migrating your data from one environment to another environment?

776


suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?

6621


Why update strategy and union transformations are active?

816


Can we create two repositories on same database instance in oracle?

852


Scheduling properties,whats the default (sequential)

1690


define galaxy repository in informatica

1944


Have you worked with/created Parameter file

1417


What is the format of informatica objects in a repository?

816


Different qualification between a related rotate toward the sky and isolates look upward?

777


What does reusable transformation mean?

872


lookup transformation with screenshots

3772


Explain the informatica workflow?

825


Enlist the various types of transformations.

748