Product Join in Datastage

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
amit_dwh
Participant
Posts: 22
Joined: Tue Apr 11, 2006 6:04 am

Product Join in Datastage

Post by amit_dwh »

Hi

How could a product join be inmplemented in Datastage Px as join stage supports only left , right , inner and full outer joins.

Thanks
Top
salil
Participant
Posts: 46
Joined: Thu Oct 13, 2005 5:41 am

Re: Product Join in Datastage

Post by salil »

amit_dwh wrote:Hi

How could a product join be inmplemented in Datastage Px as join stage supports only left , right , inner and full outer joins.

Thanks
Try to do the inner join based on Key columns as some dummy Value.

IHTH
A printer consists of 3 main parts: the case, the jammed paper tray and the blinking red light.
Top
Post Reply

Return to “IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)”