Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between view and materialised view?
- 4 Answers
- 13070 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 is the Process to creating lookup transformation in informatica
Hi friends I want to know about what r the dimensions in the banking porjects and genarally how many tables r in project ?
Quickly characterize reusable change?
Briefly define reusable transformation?
I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.
What are the types of caches in lookup? Explain them.
is it possible to index the data in cache of lkp transformation ?
Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?
Explain pushdown optimization $pushdownconfig parameter - informatica
How do you handle two sessions in Informatica
How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?
What are the limitations of joiner transformation?
Explain target update override in informatica
What is a surrogate key?
How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.
