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

Answer Posted / amit

when we use conneted type of lookup then we use dynamic
caches& when we use unconncted lookup in the modelling we
use static cache

Is This Answer Correct ?    2 Yes 10 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How can you generate reports in informatica?

668


How union transformation is used?

670


How do you use reject loader.

2186


How to extract the informatica rejected data?

847


Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?

762






Which files are created during the session rums by informatics server?

799


How to go to the older version for a mapping?

686


What is an Integration service in Informatica?

801


If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?

1118


What are different types of transformations available in informatica?

668


What are the components of workflow manager?

674


What do you mean incremental aggregation?

716


In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.

1623


can we override a native sql query within informatica? How do we do it?

743


What is an expression transformation in informatica?

634