What happens when a Return port is not specified in an Unconnected Informatica Lookup

An unconnected lookup in Informatica can return only one port’s value. This is usually the port which is marked as ‘R’ in the Ports tab of the lookup transformation

But if there is only one Output port in the lookup transformation and all the other other ports are the ones used in the condition of the lookup, the unconnected lookup by default returns the output port. There is no need of specifying the return port.

However if there are multiple output ports, it is mandatory to specify the return port.

Join the Conversation

1 Comment

  1. Very helpful! It is common to run into problems like this when we are new to using the software especially something complicated like Informatica so quick and easy tutorials such as these are very useful.

Leave a comment

Your email address will not be published. Required fields are marked *