CODEWITHSUNDEEP
lookupinformatica-powercenter
staples
staples

Reputation: 424

Informatica Unconnected Lookup parse error

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:

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:

Other information:

Upvotes: 1

Views: 9473

Answers (2)

derrik brown
derrik brown

Reputation: 11

  1. Its case sensitive, try to match it.
  2. try lookupOverrideParsingSetting = 2 in custom properties at session level (under config object tab).

Upvotes: 1

Marek Grzenkowicz
Marek Grzenkowicz

Reputation: 17353

The SQL Override query has to contain rfb_id.

By default, the Integration Service executes a lookup query (automatically generated or provided by the developer) once and stores the result in a cache file. Later, the cache file is queried for every input row. The cache must contain values both for the output ports (so they can be returned) and for the input ports (so the incoming values can be compared with the cached lookup source based on the lookup condition).

Upvotes: 1

Related Questions