Lookup Stage

[Raftsman]

I am trying to perform a lookup on a table and all records are being rejected
The two keys that I am joining are

TypeA Char (30)
TypeB VarChar(20)

I changed the types so that they would be the same type and length and still they are all rejected. Can someone please tell me what I am doing wrong.

Thanks

[Krazykoolrohit]

Try trimming the data before lookup. trim them for any spaces

[DSguru2B]

Its pretty obvious that column TypeA is of length 30 and type char. That means if you have "Alpha" as a value in TypeA, it will still have length of 30, whereas if you have the value "Alpha" in a colum varchar of length 30, its length will only be 5.
Krazykoolrohit is right, trim the inputs and change the char to varchar.

[ray.wurlod]

If you trim a Char datatype in a parallel job, the result is immediately padded with the character specified in APT_STRING_PADCHAR. You will therefore also need to convert both columns (only temporarily if necessary) to VarChar.

[tagnihotri]

APT_STRING_PADCHAR, trim sometimes don't actually trim the collumns which are padded with funny characters (depending on the default value of the env variable). So better check the collumn data, which may not be actually same (i.e may be padded with these funny values) !!

[Raftsman]

I used the modify to convert the CHAR to VARCHAR. Is there a performance difference between the MODIFY and TRANSFORMER stage? Which is better to use?

Thanks

[Krazykoolrohit]

You dont need to specify anything for conversion between char and varchar. Or am i in the server frame of mind?

Its been time since i touched the parallel pallete.

[Raftsman]

Is it possible to user to different key lookups in one lookup stage.

i.e. Field_A.input = B.Code_Table
Field_C.input = B.Code_Table

How do I join multiple fields to one Code table field.

Thanks