Hi,
Iam Joing two Stages with one stage as "Dataset" and another stage is "DB2" , joining with three KEY columns.
When i execute the Query in DB2, iam getting "FOUR" records but the same JOIN query is giving me "EIGHT" records in DataStage which is repeated rows[4*2=8]
If any additional info pls get back to me...
Thanks in advance..
DataStage Parallel Edition Error (Join Stage)
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Hi Ray,ray.wurlod wrote:Are your data (your input links) correctly partitioned on the join key fields? ...
I have given the right keys in partition too, but even the issue didnt change. But now iam getting the exact data without any change in the Job.
Will let u know whats happening in the Job.
Thanks,
M Gopinath
Gopinath
-
- Premium Member
- Posts: 783
- Joined: Mon Jan 16, 2006 10:17 pm
- Location: Sydney, Australia