Join

[pp]

Is there any way we can perform a join operation with a condition in the join stage?
I have 2 tables which are going into a Join component. Now what I want is that if a particular record in Table A has a null value then I want to get that value from Table B and vice verca.

How can I achieve this?

Thank you

[ray.wurlod]

Plan how you would do it in SQL. That will suggest the number of Join stages that you will require. Join stages can be cascaded.

[pp]

In sql I might have to use decode(if then else) statements to achieve this.
How can I do the same in Datastage as Transformer dosen't support 2 inputs?
Thanks.

[pp]

Or even nvl.