how u know when to use a static cache and dynamic cache in
lookup transformation.

Answer Posted / abhsihek

Hi neetu,
as i know that dynamic lookup alway increase the perfomence
compratively static cache if i am wrong please let me know.

Is This Answer Correct ?    0 Yes 8 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain the shared cache and re-cache?

615


I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.

1587


Which development components of informatica have the highest usage?

596


What are the different options available for update strategy?

580


What is lookup transformation?

604






what are 3 tech challenges/ common issues you face?

1893


What is informatica? Why do we need it?

643


Explain what is informatica metadata and where is it stored?

615


Design a mapping to load a target table with the following values from the above source?

883


How can we use mapping variables in informatica? Where do we use them?

621


What is data transformation manager process?

624


can u any challenge your project?

1612


Difference between Data and Index Caches?

662


How do you load only null records into target? Explain through mapping flow.

1509


what is the -ve test case in your project.

1855