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 […]
Author Archives: raghavwebmail
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 […]