Interested to Buy Any Domain ? << Click Here >> for more details...
Whatis the difference between View and Materialized View ?
- 11 Answers
- 56435 Views
- Satyam, Syntel, I also Faced
- E-Mail Answers
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
How to call shell scripts from informatica?
Hi, There is a session in my workflow which is running for a long time, atlast we found the cause is the missing index. My session is running via a stored procedure. Can I create an Index on the table which the stored procedure is using while my session is running? Please suggest. My Informatica version is PC 8.0.6 My Oracle APPS is 11.5.3. Thanks,
Differentiate between a repository server and a powerhouse?
Mention a few design and development best practices for informatica?
Describe expression transformation?
How to improve the performance of a session using sorter transformation?
What are the popular informatica products?
What are the different types of olap? Give an example?
difference between informatica 8.1.1 and 8.6
Explain the use of aggregator cache file?
How we can create indexes after completing the loan process?
what is $$$$?
How can we improve session performance in aggregator transformation?
What is the command used to run a batch?
can any one give some examples for pre sql and post sql(Except dropping and creating index).
