suman

• May 20th, 2005

 

connected lookup transformation and un connected look up transformation

srilu

• Jul 7th, 2005

 

connected lookup will receive input from the pipeline and sends output to the pipeline and can return any number of values 
 
Unconnected lookup can return only one column

karthik

• Sep 9th, 2005

 

connected lookup will receive input from the pipeline and sends output to the pipeline and can return any number of values.it does not contain retun port . 
Unconnected lookup can return only one column. it containn return port. 
 

Sithu

• Dec 13th, 2005

 

Connected / unconnected lookup Transformations are used in Informatica

Sithu

Gowtham

• Jan 5th, 2006

 

Connected transformation is connected to other transformations or directly to target table in the mapping. An unconnected transformation is not connected to other transformations in the mapping. It is called within another transformation, and returns a value to that transformation. Connected lookup receives input values directly from mapping pipeline whereas UnConnected lookup receives values from: LKP expression from another transformation. Connected lookup returns multiple columns from the same row whereas UnConnected lookup has one return port and returns one column from each row. Connected lookup supports user-defined default values whereas UnConnected lookup does not support user defined values.

ravi kumar guturi

• Mar 14th, 2006

 

In the lookup transormation mainly 2 types

1)connected 2)unconnected lookup

Connected lookup: 1)It recive the value directly from pipeline

                           2)it iwill use both dynamic and static

                            3)it return multiple value

                             4)it support userdefined value

Unconnected lookup:it recives the value :lkp expression

                            2)it will be use only dynamic

                            3)it return only single value

                             4)it does not support user defined values  

Anup Kumar

• Sep 14th, 2006

 

My dear ravi,

unconnected Lookup never use Dynamic cache it use only Static cache. and one thing more may be it happend by mistake but u should know that if u r giving answer it will read by many people who can be freshers and he has not much knowledge regarding cache. so it will give wrong effect to them.

rudra

• Aug 3rd, 2007

 

Hi!Lookups are two types: 1) Connected 2) Unconnected

Connected is further two types 1) Static 2) Dynamic connected lookup is used while returning single or multiple returning values, but unconnected can return only single return value. static and dynamic are the caches that can be configured during the session. in dynamic inserts and updates occurs in cache during the session while in static there will be no such process. remember whenever you use dynamic lookup, you have to place an update strategy transformation before the target table.

ANUSHA

• Sep 11th, 2011

 

Connected and Unconnected Lookup

Sreedhar Lokaray

• Nov 2nd, 2011

 

Lookup can be used as Connected or Unconnected. Apart from cache and receiving input values from pipe line, there is one more difference. If you want to use the same lookup more than one in a mapping then you should use an unconnected. At the same time if you want to use the same lookup more than one and return more than one values (connected lookup) then you should make the lookup reusable.

One more important point. It is said that unconnected lookup returns only one port and connected will return more than one. Partially it is true. Actually connected lookup will also have only one return port and the rest are output ports which can be used to get the values for the given condition in the lookup.

Hope this is clear.

SHIV

• Dec 28th, 2011

 

The main difference between connected and unconnected lookup is, we can call unconnected lookup based on some conditions but not the connected lookup.