I am calling an unconnected lookup in Informatica and I am getting this error:
ERROR : Lookup port rfb_id in lkp_V_CLAIM_ELIGBLTY_EFF_LTCG_seqid not specified in lookup override
.
.
.
Transformation Parse Fatal Error; transformation stopped...
TE_7002 [<<PM Parse Error>> [:LKP.RLKP_V_CLAIM_ELIGBLTY_EFF_LTCG_SEQID(rfb_id)]: : invalid function reference
... >>>>:LKP.RLKP_V_CLAIM_ELIGBLTY_EFF_LTCG_SEQID(rfb_id)<<<<]
My lookup is as follows
Ports:
in_rfb_id [Input]
rfb_id [Lookup]
CLAIM_ELIG_EFF_LTCG_SEQ_ID [Output, Lookup, Return]
SQL Override:
select
max(CLAIM_ELIG_EFF_LTCG_SEQ_ID) as CLAIM_ELIG_EFF_LTCG_SEQ_ID
from
$$FAR_CR_VW.V_CLAIM_ELIGBLTY_EFF_LTCG
-- where rfb_id = in_rfb_id
group by rfb_id --
Condition:
rfb_id = in_rfb_id
Other information:
data types are the same between lookup and expression, both integer
SQL returns a one column list of 962 integers