Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between view and materialised view?
- 4 Answers
- 13020 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
What are the tasks that source qualifier perform?
How do you remove duplicate records in informatica? And how many ways are there to do it?
One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?
What are the guidelines to be followed while using union transformation?
How to extract sap data using informatica?
What are pre and post-session shell commands?
explan ur project architecture?
Explain lookup transformation source types in informatica
How many ways are there to do 'remove duplicate records in informatica'?
How do you load first and last records into target table?
Explain informatica architecture - version 8 / 9
How to join three sources using joiner? Explain though mapping flow.
Can we create multiple integration service on single repository?
What are the different versions of informatica?
What are the types of schemas we have in data warehouse and what are the difference between them?
