outer join -Job design
Moderators: chulett, rschirm, roy
outer join -Job design
How to design a job for outer join..lets say one stream is oci and other refernce is a file and the target output shd be outer join or right outer join. thanks in advance.
Re: outer join -Job design
Please refer to the Join Stage of the DataStage Job Developer's Guide. It explains the steps of creating outer join.
BANA KAMILA
BI, Data Warehouse and Database Consultant
BI, Data Warehouse and Database Consultant
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
There is no Join stage in server jobs. A lookup in a Transformer stage naturally performs a left outer join. It can be proven that, by exchanging the left and right links, any right outer join can be constructed as a left outer join. This answer ignores issues of "performance", but so does the question.
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.