How do we implement materialized view?when to use materialized view?
- 1 Answers
- 7302 Views
- TCS, I also Faced
- E-Mail Answers
Answer / 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 |
What is a repository manager?
what is the difference between onsite & client site?
What is main use of mapplet?
How many repositories can be created in informatica?
How to extract the informatica rejected data?
tell me the datawarehouse defination,and it is maintaing hystorical data meaning,what is the use
performance wise which one is better in joiner and lookup transformation?why?explain clearly?
can we see default group,when we use router?if yes how?
What is the fact table?
following source name gender ramya female ram male deesha female david male kumar male i want the target male female ram ramya david deesha kumar any body give solution above question?
How we can confirm all mappings in the repository simultaneously?
what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?
Teradata 
