Whatis the difference between View and Materialized View ?
- 11 Answers
- 53056 Views
- Satyam, Syntel, I also Faced
- E-Mail Answers
Answer Posted / surajit n bhowmick
A View is just a stored query and has no physical role.
Once a view is instantiated, performance can be quite good,
until it is aged out of the cache.
A materialized view has a physical table associated with
it, it does not have to resolve the query each time it is
queried. Depending on how large the result and how complex
the query, a materialized view should perform better.
| Is This Answer Correct ? | 12 Yes | 4 No |
Post New Answer View All Answers
How can we update a record in the target table without using update strategy?
What is the advantage of informatica?
While importing the relational source definition from the database, what are the metadata of source that will be imported?
What is fact table? Explain the different kinds of facts.
What is the benefit of session partitioning?
can any one explain about dataflow in the informatica project for bank domain....thanks is advance
During the running session, output files are created by informatica server. Enlist few of them.
explain one complex mapping with logic? sales project?
Tell me about Propagate functions in informatica
Enlist few areas or real-time situations where informatica is required.
Describe expression transformation?
What is aggregate cache in aggregator transformation?
Have you worked with/created Parameter file
How do you load only null records into target?
Is stop and abort are same in informatica?
