when will we use unconnected & connected lookup? How it
will effect on the performance of mapping?

Answer Posted / nag

Connected Lookup
Receives input values directly from the pipeline.
We can use a dynamic or static cache
Supports user-defined default values

Unconnected Lookup
Receives input values from the result of a :LKP expression
in another transformation.
We can use a static cache
Does not support user-defined default values

When you compared both basically connected lookup will
return more values and unconnected returns one value. conn
lookup is in the same pipeline of source and it will accept
dynamic caching. Unconn lookup don't have that faclity but
in some special cases we can use Unconnected. if output of
one lookup is going as input of another lookup this
unconnected lookups are favourable

Is This Answer Correct ?    2 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?

2071


What are the performance considerations when working with aggregator transformation?

915


what is the Default Source Option For Update Strategy Transformation?

990


What is rank index in rank transformation?

815


State the differences between sql override and lookup override?

872


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

7934


What is option by which we can run all the sessions in a batch simultaneously?

880


How to open an older version of an object in the workspace?

856


What is the meaning of decode in informatica?

877


Mention some types of transformation?

807


explain one complex mapping with logic? sales project?

6409


Explain the shared cache and re-cache?

831


where to store informatica rejected data? How to extract the informatica rejected data?

786


What do you understand by SOA of Informatica?

760


1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?

1907