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
Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?
can we override a native sql query within informatica? Where do we do it? How do we do it?
How do you manage the Parameter files while migrating your data from one environment to another environment?
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 ?
Why update strategy and union transformations are active?
Can we create two repositories on same database instance in oracle?
Scheduling properties,whats the default (sequential)
define galaxy repository in informatica
Have you worked with/created Parameter file
What is the format of informatica objects in a repository?
Different qualification between a related rotate toward the sky and isolates look upward?
What does reusable transformation mean?
lookup transformation with screenshots
Explain the informatica workflow?
Enlist the various types of transformations.