Interested to Buy Any Domain ? << Click Here >> for more details...
Whatis the difference between View and Materialized View ?
- 11 Answers
- 56787 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
What are multi-group transformations?
How to start a workflow using pmcmd command?
How can you generate reports in informatica?
What is the meaning of decode in informatica?
What is meant by target load plan?
Describe data concatenation?
How to Create a folder using pmrep command?
How we can use union transformation?
What is sequence generator transformation in informatica?
I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)
Define enterprise data warehousing?
What is the use of target designer?
What is Cognos script editor?
Explain target update override in informatica
What are some examples of informatica etl programs?
