Home > Software > Data-Warehouse > Informatica
Interview Questions   Tutorials   Discussions   Programs   

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




443
views
asked marvit September 20, 2014 07:59 AM  

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


           

1 Answers



 
answered By vishnoiprem   0  
A. 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
Moreover if the mapping requires multiple lookup using same lookup conditions then its better to use unconnected lookup
& call the lookup wherever required.This also prevents the mapping from being complex.
flag   
   add comment

Your answer

Join with account you already have

FF

Preview


Ready to start your tutorial with us? That's great! Send us an email and we will get back to you as soon as possible!

Alert