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.

One thought on “What happens when a Return port is not specified in an Unconnected Informatica Lookup”

  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 Reply

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