Page 1 of 1
Self Join in Datastage
Posted: Fri Dec 03, 2010 1:23 am
by 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.
Posted: Fri Dec 03, 2010 4:23 am
by 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.
Posted: Fri Dec 03, 2010 4:32 am
by 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.
Posted: Sun Dec 05, 2010 10:42 pm
by 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.