Interested to Buy Any Domain ? << Click Here >> for more details...
How do we implement materialized view?when to use materialized view?
- 1 Answers
- 7810 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / chanti
A materialized view provides indirect access to table data by storing the results of a query in a separate schema object. Unlike an ordinary view, which does not take up any storage space or contain any data.
A materialized view can be stored in the same database as its base table(s) or in a different database.
Materialized views stored in the same database as their base tables can improve query performance through query rewrites. Query rewrites are particularly useful in a data warehouse environment.
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
How can we remove the duplicates from flat file source?
What are the types of caches in lookup? Explain them.
Informatica settings are available in which file?
How do you manage the Parameter files while migrating your data from one environment to another environment?
Enlist some properties of sessions.
Clarify the aggregator change?
What is a surrogate key?
How do you load unique records into one target table and duplicate records into a different target table?
How might you approve all mappings in the archive all the while?
tell me about your project functionality
What are the different lookup cache(s)?
How do you load first and last records into target table?
What are mapplets? How is it different from a Reusable Transformation?
Which transformation is needed while using the Cobol sources as source definitions?
Explain about Informatica server process that how it works relates to mapping variables?
