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.