A lookup transformation configured as an Unconnected Lookup can only return one port. However, there are times when you need to quickly modify a mapping to return more than one port from the unconnected lookup. There are two ways to do this:- 1. To convert the unconnected lookup to a connected lookup in the pipeline […]
Tag Archives: Return Port
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 […]