Page 1 of 1
join stage
Posted: Tue Jun 26, 2007 10:46 am
by 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
Re: join stage
Posted: Tue Jun 26, 2007 11:43 am
by 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.
Re: join stage
Posted: Tue Jun 26, 2007 8:47 pm
by ThilSe
sri1111 wrote: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
Re: join stage
Posted: Tue Jun 26, 2007 8:47 pm
by ThilSe
sri1111 wrote: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
Re: join stage
Posted: Tue Jun 26, 2007 8:48 pm
by ThilSe
sri1111 wrote: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
Posted: Tue Jun 26, 2007 10:54 pm
by 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.