When will u go for Dynamic Cache and Persistent Cache? Pls
explain with an example?
Answer Posted / rayudu
If the lookup cache doesnt change between mutiple runs and
if we know that the lookup data doesnt change then we will
go for Persistant cache.
If the loopup cache changes between multiple session runs
and to keep the target table and lookup cache synchronized
we will use dynamic lookup cache .
regards,
rayudu.
| Is This Answer Correct ? | 7 Yes | 4 No |
Post New Answer View All Answers
What do you understand by a term domain?
What is joiner transformation?
What is the Rank index port in Rank transformation?
What you know about transaction control transformation?
What are the components of Informatica? And what is the purpose of each?
Quickly characterize reusable change?
suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?
what are factless facts? And in which scenario will you use such kinds of fact tables.
How do you use reject loader.
What are the designer tools for creating transformations?
How union transformation is used?
Explain informatica architecture - version 8 / 9
Explain the etl program with few examples.
What is substr in informatica?
Explain sessions. Explain how batches are used to combine executions?