Page 1 of 1

need help for join stage

Posted: Mon May 10, 2010 2:17 pm
by meenakshid
Hi,
I have two input files.
input file1: three column with three rows

input file2: three column with four rows

requirement is to get 3 output files.
1: together data from both input files
2: matched columns for file1 only
3:matched columns for file2 only

I really appreciate your help.
Thanks,
Meenakshi

Posted: Mon May 10, 2010 3:47 pm
by ArjunK
Full Outer join and a transformer should do it.

Posted: Mon May 10, 2010 4:17 pm
by ray.wurlod
Yes, or full outer join and Filter.

Make sure that data are key partitioned and sorted on the Join key.