Page 1 of 1
Full Outer of 3 files...
Posted: Thu Dec 29, 2011 10:02 am
by kaps
I am wondering if there is another way of doing full outer between 3 or more files. Now, I use join stage to join two files and the output will be joined to the 3rd file. Is there a better way ?
Posted: Thu Dec 29, 2011 10:04 am
by chulett
Nope... at least not that I'm aware of.
Posted: Thu Dec 29, 2011 4:55 pm
by ray.wurlod
Join stage does support more than two inputs (though the joins are still done pairwise under the covers).
Posted: Fri Dec 30, 2011 9:32 am
by kaps
Ray - Yes. Join stage does support more than 2 inputs but we can't do full outer join between all the inputs.
Posted: Fri Dec 30, 2011 1:07 pm
by pandeesh
kaps wrote:Ray - Yes. Join stage does support more than 2 inputs
yes,only inner join we can.
Posted: Sat Dec 31, 2011 2:15 am
by jwiles
Inner Join, Left Outer and Right Outer support more than 2 inputs. Full Outer supports only 2 inputs.
The method you are using to do your full outer join between all of your inputs is the correct method (using multiple joins).
Regards,