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.
Using Join stage for joining three inputs
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: