join stage

[sri1111]

i have a px job which is joining some cols from look up table input is a file and out put is aslo a file , it has 3 keys on which i have to do lookup .Job is running fine without any warnings or error but it is not finding any match but there are keys in both table and file which matches .
if i do inner join nothing is passing.

Can any one help me out here.
Thanks

[mctny]

There might be some space or other invisible characters before or after the actual value of the columns, for that reason you should use trim function for both the main input columns as well as the look up columns.

[ThilSe]

i have a px job which is joining some cols from look up table input is a file and out put is aslo a file , it has 3 keys on which i have to do lookup .Job is running fine without any warnings or error but it is not finding any match but there are keys in both table and file which matches .
if i do inner join nothing is passing.
Hi Sri,

Can any one help me out here.
Thanks

Make sure that the input is partioned, sorted on the join keys in both the links

Make sure that the order of keys given as the join keys and in the sort stage is same

Regards,
Senthil

[ThilSe]

i have a px job which is joining some cols from look up table input is a file and out put is aslo a file , it has 3 keys on which i have to do lookup .Job is running fine without any warnings or error but it is not finding any match but there are keys in both table and file which matches .
if i do inner join nothing is passing.
Hi Sri,

Can any one help me out here.
Thanks

Make sure that both the inputs are partioned, sorted on the join keys in both the links

Make sure that the order of keys given as the join keys and in the sort stage is same

Regards,
Senthil

[ThilSe]

i have a px job which is joining some cols from look up table input is a file and out put is aslo a file , it has 3 keys on which i have to do lookup .Job is running fine without any warnings or error but it is not finding any match but there are keys in both table and file which matches .
if i do inner join nothing is passing.
Hi Sri,

Can any one help me out here.
Thanks

Make sure that both the inputs are partioned, sorted on the join keys in both the links

Make sure that the order of keys given as the join keys and in the sort stage is same

Regards,
Senthil

[Minhajuddin]

Yeah, As it has already been said, Try to trim your keys and leave the partitioning method to Auto or Hash with all the three columns.
This should do the trick.