What is difference between a connected look up and
unconnected look up?

Answer Posted / ande

Connected LookUp returns multiple values to other
Transformation whereas unconnected lookup return single
value, If condtion is match then connected lookup returns
user defined default values whereas unconnected lookup
returns null values, connected lookup supports dynamic as
well as static caches whereas unconnected lookup supports
static cache only
regards,
ande

Is This Answer Correct ?    52 Yes 6 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How do you migrate data from one environment to another?

637


What is a predefined event?

653


What are the performance considerations when working with aggregator transformation?

670


What is joiner change?

665


What does refresh system mean, and what are its distinctive choice?

563






What is the function of union transformation?

610


How to display session logs based upon particular dates. If I want to display session logs for 1 week from a particular date how can I do it without using unix. ?

1599


Define sessions in informatica etl?

610


What is status code in informatica?

572


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

616


Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.

1830


What can we do to improve the performance of informatica aggregator transformation?

610


What is the Rank index port in Rank transformation?

664


What are the types of presistent cache in look up tr.

1541


What is the meaning of up gradation of repository?

1381