Interested to Buy Any Domain ? << Click Here >> for more details...
Whatis the difference between View and Materialized View ?
- 11 Answers
- 56364 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
Is stop and abort are same in informatica?
What are the types of presistent cache in look up tr.
How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?
How can you increase the performance in joiner transformation?
How to partition the Session?
What is the Rank index port in Rank transformation?
How to start a workflow using pmcmd command?
How can repository reports be accessed without sql or other transformations?
What is an expression transformation?
source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.
Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?
what is diff b/t sorter t/r and agg have the option sorter property...
What is the need of etl tools?
What is the cumulative sum and moving sum?
How can you generate reports in informatica?
