DSXchange

The partitioning on the lookup stage is set to auto.
I do a lookup to the datastage where the key values, incomming and on the dataset, are varchar.
This works when the varchar contains only numerics e.g. '13300'
This does not work when the varchar contains non-numerics e.g. 'VDB_120'.

Has anyone else experienced this problem?

What do you mean by doesn't work? Do you just not get an expected match, or does the job fail?

Both varchar columns are defined alike, yes? Are both datasources of the same type (sequential file, database, dataset for example)?

Typically, you don't get a match on varchars because the data doesn't exactly match (that one was obvious, wasn't it? ) It may LOOK like it does when you do a peek or view data, but there could be trailing spaces, non-printable characters or something that isn't readily visible using peek/view data. You may just need to clean up your data using some form of Trim() or Convert() before entering the lookup stage.

Regards,

It may also not work, even if the data do look the same, if they are encoded differently (for an extreme example, ASCII and EBCDIC).