SQl Server is case sensitive. If you have given the port names in the lookup lower case, make sure your override matches that.
Unfortunately everything is in upper case..
But thanks for hint.
Any other ideas?
Can you please generate SQL from Lookup override and then edit the query. Dont copy the working query from your SQL. It might not work.
Modify the query that Infomratica generates.
I tried many other steps but didn't help.
What helped was a fresh recreation of lookup, I do not know what could be wrong.
The discussion might be closed.
The problem lies with the select statement in the lookup. If you lookup up says:
Select columnA From tableb
you need to change that to
Select columnA as ColumnA From tableb
don't ask me why this problem is but that solved my problem