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
lookup transformation with screenshots
Explain what transformation and how many are there in informatica?
what is the hint? how to use it to reduce the query processing in program?
Design time, run time. If you don't create parameter what will happen
What is the difference between a repository server and a powerhouse?
Difference between Target-based loading and constraint-based loading?
What is meant by lookup transformation? Explain the types of lookup transformation?
Have you worked with/created Parameter file
Mention some types of transformation?
What are the various types of transformation?
While importing the relational source definition from the database, what are the metadata of source that will be imported?
Explain pushdown optimization $pushdownconfig parameter - informatica
How do you change a non-reusable transformation to reusable transformation?
Enlist the tasks for which source qualifier transformation is used.
What do you understand by term role-playing dimension?