When do we use dynamic cache and static cache in connected
and unconnected lookup transformations?

Answer Posted / vinod saini

Dynamic cache uses for updation of Master Table & SCD type 1
Static uses for Flatfile

Is This Answer Correct ?    3 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

When do you use sql override in a lookup transformation?

776


Implementation methodology

1479


What is rank transformation?

755


Which transformation is needed while using the Cobol sources as source definitions?

931


can u give example for factless fact table

5958


Enlist the advantages of informatica.

831


What is data transformation manager process?

825


Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?

766


What are the steps involved in the migration from older version to newer version of Informatica Server?

1827


explan ur project architecture?

1824


WHAT IS EDM?WHAT IS THE USE IN INFORMATICA? chandumba2005@gmai.com

1705


How to delete duplicate row using informatica?

797


What is flashback table ? Advance thanks

1690


what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?

2054


Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance

1785