Using Join stage for joining three inputs

Sravani · Post by **Sravani** » Wed Apr 23, 2008 8:51 am

Hi,
I have created a job where threre are three inputs and I am linking those 3 inputs to a join stage. The output of the join stage should be the as decribed below.

Input 1:
J1 J2 J3 C1 C2

Input 2
J1 J2 J3 C3

Input 3
J1 J2 J3 C4

WHere J1, J2, J3 are the key columns on which I am performing the join and the output should be

J1 J2 J3 C1 C2 C3 C4

But when I am using FullOuter join and the all the 3 input files contains 2 records each I am getting 8 records where as I should get 2 records only.

Can anybody help me in resolving this issue?

Thanks.

ray.wurlod · Post by **ray.wurlod** » Wed Apr 23, 2008 3:13 pm

Moderator: please move to parallel forum

ray.wurlod · Post by **ray.wurlod** » Wed Apr 23, 2008 3:14 pm

With full outer join you should get eight.