DSXchange

Hi,

I am facing an issue with the lookup stage in DataStage.Please find the details below.

I am having sequential file as source which has a column name as below

column name Datatype
question_description Varchar

Now my requirement is i should have a lookup on the dimension table on question_description column and pass only the records that are matching

I have linked the source column and the lookup column in the lookup stage and enabled the property lookup failure reject or else continue to the target

The issue is i have record What is your name? in the source record and the same record exists in my dimension table, but during the lookup the lookup stage is rejecting the record eevnthough it is existing in the table.

Can anyone please help me to figure out this

Are the two values spelled, trimmed and cased identically? Is your VarChar large enough for this string?

Hi,

Please find the answers for the questions you have mentioned.

a)The two values are spelled,trimmed and cased identically.
b)The Varchar length has been specified to 256.

Please find the sample record.

What is your name?(Record from source)
What is your name?(Record from lookup table)

Thanks,
Naresh

From the looks, it must grab the correct row.

Are there any successful lookups also? If yes, try to find what is common in the successful ones which is not in the failed.

Could there be an issue with NLS or local language features ? Special Chars ?

How many nodes is this running on? What are the partitioning settings?

That can also cause a lookup failure, even when it should otherwise match.