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.
Self Join in Datastage
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 26
- Joined: Mon Oct 25, 2010 6:09 am
- Location: Hyderabad
Self Join in Datastage
Thanks & Regards,
HARIRAM
Software Engineer
HARIRAM
Software Engineer
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Yes. Have the same data stream coming in on both links.
Properly key-partitioned and sorted, of course.
Code: Select all
+--------------V
-----> Copy Join ----->
+--------------^
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Participant
- Posts: 26
- Joined: Mon Oct 25, 2010 6:09 am
- Location: Hyderabad
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.
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.
Thanks & Regards,
HARIRAM
Software Engineer
HARIRAM
Software Engineer