Interested to Buy Any Domain ? << Click Here >> for more details...
How do we implement materialized view?when to use materialized view?
- 1 Answers
- 7796 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
What are different types of transformations available in informatica?
What is a mapplet/worklet in informatica?
Explain what are the different versions of informatica?
What does command task mean?
Is it possible to create multiple domains on a single Informatica server?
What is a pre-defined event and user-defined event?
How many input parameters can exist in an unconnected lookup?
How can informatica be used for an organization?
What is a standalone command task?
What is an unconnected transformation?
What is a shortcut and copy in Informatica and how two are different with each other?
What is update strategy transform?
What are the modules in Power Center
Which version configuration tool used in ur project?
What are the tasks that can be performed using sq?
