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
How might one distinguish in the case of mapping is right or not without associating session?
Write the advantages of partitioning a session?
What is repository manager?
Informatica Server and Client are in different machines. You run a session from the server manager by specifying the source and target databases. It displays an error. You are confident that everything is correct. Then why it is displaying the error?
Which is the t/r that builts only single cache memory?
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.
What are the data movement modes in informatica?
How to delete duplicate row using informatica?
What is mapplet in informatica?
What are the databases that informatica can connect to windows?
What is fact table? Explain the different kinds of facts.
What do you understand by term role-playing dimension?
differences between service based and product based?
How to create the source and target database connections in server manager?