top button
Flag Notify
    Connect to us
      Site Registration

Site Registration

Informatica Unconnected Lookup parse error

+1 vote
3,074 views

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

posted Jun 9, 2014 by Amit Sharma

Share this question
Facebook Share Button Twitter Share Button LinkedIn Share Button

2 Answers

0 votes

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).

answer Jun 10, 2014 by Shweta Singh
0 votes

Error is coming because there is no reference of rfb_id in Lookup Override query.
Add the rfb_id column in your query and execute.

answer Jun 11, 2014 by Shatark Bajpai
Similar Questions
+2 votes

In unconnected lookup, what are the other transformations that can be used in place of that expression transformation?

+1 vote

What are the differences between Connected and Unconnected Lookup?

+2 votes

I have been trying a lookup and update strategy transformation but for some reason its not working.

I have a disconnected lookup in my mapping which is called based on a particular condition and when the look up is null , I tried to set a variable to 'INS',REJ,UPD,DEL..

The new variable in my agg_trans-INS_UPD_DEL is not getting linked to the upd_strategy trans. I'm able to move the variable from expression to update_strategy but dont see the link being displayed..

enter image description here

...