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

Informatica - What is the difference between Connected and UnConnected Lookup Transformation.Give one or two examples?




680
views
asked marvit September 20, 2014 08:01 AM  

What is the difference between Connected and UnConnected Lookup Transformation.Give one or two examples?


           

1 Answers



 
answered By vishnoiprem   0  
Below are the difference between Connected Lookup and unconnected Lookup:

1) Connected lookup receives input values directly from the pipeline whereas Unconnected lookup Receives input values from the result of a :LKP expression in another transformation.
2) You can use a dynamic or static cache in connected lookup whereas in connected lookup you can use static cache only.
3) In connected lookup, cache includes all lookup columns used in the mapping (that is, lookup source columns included in the lookup condition and lookup source columns linked as output ports to other transformations) whereas in unconnected lookup, Cache includes all lookup/output ports in the lookup condition and the lookup/return port.
4) Connected lookup can return multiple columns from the same row or insert into the dynamic lookup cache whereas Unconnected lookup designate one return port (R). Returns one column from each row.
5) In connected lookup, if there is no match for the lookup condition, the PowerCenter Server returns the default value for all output ports. If you configure dynamic caching, the PowerCenter Server inserts rows into the cache or leaves it unchanged. In unconnected lookup, If there is no match for the lookup condition, the PowerCenter Server returns NULL.
6) Connected lookup pass multiple output values to another transformation. Link lookup/output ports to another transformation.Unconnected lookup pass one output value to another transformation. The ookup/output/return port passes the value to the transformation calling :LKP expression.
7) Connected lookup supports default values in the port whereas unconnected lookup doesn't support the default
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