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 […]

How to remove the hash symbol from Informatica header output

In Informatica there is a very handy option to automatically generate column names as a header row in the flat file output. This option serves its purpose except for the fact it places a “#” (hash) symbol at the beginning of the header row by default. And, it seems there is no easy way to […]