DSXchange

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..

Are your data (your input links) correctly partitioned on the join key fields?

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

This time right data goes into right partition.

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