Interested to Buy Any Domain ? << Click Here >> for more details...
How do we implement materialized view?when to use materialized view?
- 1 Answers
- 7803 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 is expression transformation?
What is the benefit of session partitioning?
How to extract sap data using informatica?
What is sorter transformation?
What are the different types of olap? Give an example?
What happens when a session fails and you click on recover?
Under which circumstances, informatica server creates reject files?
What are the advantages of using informatica as an etl tool over teradata?
Design time, run time. If you don't create parameter what will happen
Explain lookup transformation source types in informatica
Partition, what happens if the specified key range is shorter and longer
How many ways are there to do 'remove duplicate records in informatica'?
what is the size ur source like(file system or database)? how many record daily come u r banking project?
I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.
What is a predefined event?
