unconnected lookup & invalid function reference

[akotmaale]

hi,

i've created a unconnected lookup. I suppose it is fine.
There is an input port, lookup port and return value.
Input and lookup is a decimal number.
I try to use this lookup in my transformation expression like this:
:LKP.lkp_name(1). But I get this invalid function reference error.
What could be wrong??
I'm using Informatica PowerCenterRT Designer 6.2

Best regards

Akotmaale

 

[Sridharan]

Did you check if you have connected the Input Port of the Lookup Transformation from some other port??? If so, then you need to disconnect it i.e. Unconnected Lookups Inputs shouldn't be connected with other Transformation.

Sri

 

[akotmaale]

thnx for your advice. Well, the problem was, that this unconnected lookup was not in mapping designer area. I thought that it is enough to create a valid unconnected lookup and then just use it in transformation with this :lkp.lookup_name(params) notation.

But I have another question: this unconnected lookup works fine in transformations like expressions. But what I need is to use it in Source Qualifier. Just to impact my SQL-Statement. But this ETL-Engine does not change this to an expression, but use it as a string.
So the SQL-Statement is wrong.
Is there any possibility to use an unconnected lookup in Source Qualifier???

Thnx in advace.

Akotmaale

PS. As workaround I use a stored procedure instead of unconnected lookup.

 

[Dagon]

No, you can't. They are designed to be used in expressions. If you want to do the equivalent in a source qualifier, you should do a join between your source table and the lookup table.

 

[akotmaale]

Thnx