Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between view and materialised view?
- 4 Answers
- 13202 Views
- I also Faced
- E-Mail Answers
Answer Posted / atiric sofrware(raja)
Views contains query whenever execute views it has read from
base table
Where as Materialised views loading or replicated takes
place only once which gives you better query performance
Refresh materialised views
1.on commit
2. on demand
(Complete, never, fast, force)
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
Implementation methodology
What is lookup transformation?
How to update or delete the rows in a target, which do not have key fields?
What is domain and gateway node?
what is degenerated dimension?
Explain what is informatica metadata and where is it stored?
What is a surrogate key?
Why do we need informatica?
According to his methodology what all you need before you build a datawarehouse
What is a repository manager?
How to load a Dimension ? and how to load a fact table?
How is union transformation utilized?
What is the different lookup cache(s)?
What is the use of an aggregator cache file?
What is blocking transformation?
