when do we use static cache and when do we use dynamic cache
in lookup transformation? with example.



when do we use static cache and when do we use dynamic cache in lookup transformation? with exampl..

Answer / swapna

static cache is used when the records in the source does not update more frequently.

dynamic cache is used when the records in the source frequently updates.

Is This Answer Correct ?    1 Yes 0 No

Post New Answer

More Informatica Interview Questions

Under which circumstances, informatica server creates reject files?

0 Answers   Informatica,


What is meant by LDAP users?

0 Answers  


what is the location of parameter file in informatica?

1 Answers   TCS,


What are set operators in Oracle

3 Answers   Deloitte, Wipro,


Plz can anybody send Informatica and Cognos FAQ Plz To thid ID ppradeep_dwh@yahoo.co.in

1 Answers  


Howmany ways yoU can update a relational source defintion and what are they?

1 Answers  


difference between informatica 8.1.1 and 8.6

0 Answers   TCS,


What are the reusable transformations?

0 Answers   Informatica,


I have a scenario which load the data frm single source to 2 targets as T1, T2, and T1 have a P.K and T2 have F.K relations. first data has to load in T2, and then data load to T1 if that record exist in T1... how can we acheive it?

2 Answers   Ness Technologies,


what is the diff b/w cached and unchaed look ups

3 Answers   IBM, TCS, Wipro,


Issue with Update override at Target table in Informatica.

2 Answers  


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.

0 Answers   CTS,


Categories