outer join -Job design

cnew · Post by **cnew** » Tue Oct 30, 2007 4:06 pm

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.

crouse · Post by **crouse** » Tue Oct 30, 2007 4:09 pm

Is this by chance for an interview?

bkamila · Post by **bkamila** » Tue Oct 30, 2007 4:41 pm

Please refer to the Join Stage of the DataStage Job Developer's Guide. It explains the steps of creating outer join.

ray.wurlod · Post by **ray.wurlod** » Tue Oct 30, 2007 8:29 pm

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.

DSXchange

outer join -Job design

outer join -Job design

Re: outer join -Job design