Self Join in Datastage

[harivasireddy]

Hi All,


Is it possible to do the Self join by using Join stage.
If it is possible let me know the procedure involved in it?


Thanks in Advance.

[ray.wurlod]

Yes. Have the same data stream coming in on both links.

Code: Select all

               +--------------V
    ----->   Copy             Join  ----->
               +--------------^

Properly key-partitioned and sorted, of course.

[harivasireddy]

Thanks for your immediate response.

But Iam not clear with this.
could you please tell me in a detailed manner.
what is the type of the join I need to mention in Join stage
and what are all other options I need to specify.
and what is the expected output in my output link.

Also can we perform the self join other than join stage.

[abhijitg]

The type of join you select depends on what your requirements are. As to an explanation of the options, I would turn to Parallel Developers Guide.