DataStage Parallel Edition Error (Join Stage)

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
Gopinath
Participant
Posts: 52
Joined: Wed Apr 25, 2007 2:18 am

DataStage Parallel Edition Error (Join Stage)

Post by Gopinath »

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..
Gopinath
ray.wurlod
Participant
Posts: 54582
Joined: Wed Oct 23, 2002 10:52 pm

Post by ray.wurlod »

Are your data (your input links) correctly partitioned on the join key fields?
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Gopinath
Participant
Posts: 52
Joined: Wed Apr 25, 2007 2:18 am

Post by Gopinath »

ray.wurlod wrote:Are your data (your input links) correctly partitioned on the join key fields? ...


Hi Ray,

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
keshav0307
Premium Member
Premium Member
Posts: 783
Joined: Mon Jan 16, 2006 10:17 pm

Post by keshav0307 »

This time right data goes into right partition.

have you used hash partition on the all column used as join keys?
Post Reply