The Source Qualifier Contains an unbound field

Severity: ERROR
Timestamp:
Node: node01
Thread: MAPPING
Process ID: 5940
Message Code: TE_7020
Message: Internal error. The Source Qualifier [SQ_sc_S] contains an unbound field [RID]. Contact Informatica Global Customer Support.


Solution

This issue occurs when there are one or more unconnected ports between the Source and Source Qualifier.

Connect all the unconnected Ports with correct datatypes.

How to remove Lookup OrderBty clause added automatically By Informatica

End your Lookup Override SQL with --

SELECT
col1 as col1
col2 as col2
WHERE col1 ="something"
and col2 in (9017,9014) --