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

Answer Posted / bc

we can use dynamic and static cache in connected
lookup..and we can use only static cache in unconnected
lookup.

Is This Answer Correct ?    0 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to load a Dimension ? and how to load a fact table?

956


Is stop and abort are same in informatica?

572


tell me the rules and responsblites in our project(my project is development)

1502


What are different types of transformations available in informatica?

588


How can we remove the duplicates from flat file source?

583






Define filter transformation?

626


What is the difference between router and filter?

651


What is aggregate cache in aggregator transformation?

636


What is a predefined event?

662


What is a pre-defined event and user-defined event?

579


Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?

731


What is an aggregator transformation?

617


What is difference between a gateway node and worker node?

628


How do you set a varible in incremental aggregation

1451


What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?

7681