Lookup Mismatch of Records

Nareshkurra · Post by **Nareshkurra** » Mon Jul 27, 2009 9:01 pm

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

ray.wurlod · Post by **ray.wurlod** » Mon Jul 27, 2009 10:04 pm

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

Nareshkurra · Post by **Nareshkurra** » Mon Jul 27, 2009 10:42 pm

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

Sainath.Srinivasan · Post by **Sainath.Srinivasan** » Tue Jul 28, 2009 2:13 am

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.

algfr · Post by **algfr** » Tue Jul 28, 2009 6:49 am

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

jcthornton · Post by **jcthornton** » Tue Jul 28, 2009 11:11 am

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.