i have 2 sequential files in which
one file having firstname,lastname
2nd file having firstname,e-mailaddress
now i want output as
firstname,lastname,e-mail-address...........how?
i used join stage join type as inner it does n't work...
i have 2 sequential files
Moderators: chulett, rschirm, roy
i have 2 sequential files
subhani
-
- Participant
- Posts: 527
- Joined: Thu Apr 19, 2007 1:25 am
- Location: Melbourne
Hi,
Make sure you sort the incoming records on the key prior to the join and it should work. Your problem might be the selection of a bad key column rather the join. The first name might not uniquely identify a row which might result in cross joins. Secondly by selecting an inner join you might be dropping records (not everyone has an email address).
Thanks
Abhijit
Make sure you sort the incoming records on the key prior to the join and it should work. Your problem might be the selection of a bad key column rather the join. The first name might not uniquely identify a row which might result in cross joins. Secondly by selecting an inner join you might be dropping records (not everyone has an email address).
Thanks
Abhijit
In addtion to the aboveabhijitg wrote:Hi,
Make sure you sort the incoming records on the key prior to the join and it should work. Your problem might be the selection of a bad key column rather the join. The first name might not uniquely identify a row which might result in cross joins. Secondly by selecting an inner join you might be dropping records (not everyone has an email address).
Thanks
Abhijit
a) Hash Partition the input
b) Maintain consistency in the Input key fields (ie. Trim, Upper/Lower Case).