how to perform self join
Moderators: chulett, rschirm, roy
how to perform self join
Hi,
How to perform self join using join stage in parallel
is it possible to perform a self join.
Thanks
How to perform self join using join stage in parallel
is it possible to perform a self join.
Thanks
-
- Participant
- Posts: 86
- Joined: Mon Nov 27, 2006 3:42 am
- Location: Wilmington
Re: how to perform self join
Hi,
I think you need to use the same file as right and left. then you can achive the self join in datastage.
I think you need to use the same file as right and left. then you can achive the self join in datastage.
Re: how to perform self join
Magesh_bala wrote:Hi,
I think you need to use the same file as right and left. then you can achive the self join in datastage.
Is it possible do with a single input file ?
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Yes. And your point is?
Code: Select all
+----------------+
| V
SeqFile ----> 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.
You're probably better off landing your data into a dataset, and depending on volumes using a lookup or joining the data in a second job. Of course if you insist on using only 1 input stream, you could copy this into 2 sorts based on the join keys and merge your data together. This will have rubbish results if your join key is not unique.
3NF: Every non-key attribute must provide a fact about the key, the whole key, and nothing but the key. So help me Codd.