srinivas vadlkonda

• Oct 17th, 2006

 

We can use the unconnected lookup transformation when i need to return the only one port at that time i will use the unconnected lookup transformation instead of connected.  We can also use the connected to return the one port but if u r taking unconnected lookup transformation it is not connected to the other transformation and it is not a part of data flow that why performance will increase.

sn3508

 Profile Answers by sn3508 

• Oct 25th, 2006

 

The major advantage of unconnected lookup is its reusability.  We can call an unconnected lookup multiple times in the mapping unlike connected lookup.

siraj.khan

• Aug 3rd, 2007

 

We can use the unconnected lookup transformation when we need to return the output from a single port.
If we want the output from a multiple ports at that time we have to use connected lookup Transformation.

Tarun Vig

• Oct 12th, 2007

 

Use of connected and unconnected Lookup ic completely based on the logic which we need.

However i just wanted to clear that we can get multiple rows data from an Unconnected lookup also.
Just concatinate all the values which you want and get the result from the return row of unconnected lookup and then furthur split it in the expression.

However using Unconnected lookup takes more time as it breaks the flow and goes to an unconnected lookup to fetch the results.

sridhar39

 Profile Answers by sridhar39 

• Dec 28th, 2007

 

hi,

    both unconnected and connected will provide single output. if it is the case that we can use either unconnected or connected i prefer unconnected why because unconnected doesnot participate in the dataflow so informatica server creates a seperate cache for unconnected and processing takes place parallely. so performance increases.