need help for join stage

meenakshid · Post by **meenakshid** » Mon May 10, 2010 2:17 pm

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

ArjunK · Post by **ArjunK** » Mon May 10, 2010 3:47 pm

Full Outer join and a transformer should do it.

ray.wurlod · Post by **ray.wurlod** » Mon May 10, 2010 4:17 pm

Yes, or full outer join and Filter.

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