Perform join with OR condition

[manoj_23sakthi]

Is it possible to perfor join with or condition in datastage?

Eg :

T1:
a,b
1,2
2,2

T2:

a,c
1,d
0,e

i need o/p as:

if T1.a=T2.a or T2.a=0 then c
O/p
a,b,c
1,2,d
2,2,e

[chulett]

Hi
sorry for this..
I am not able to post this in new post.

Why not? All you need to do is click on Post new topic anywhere in the appropriate forum to start a new post.

Split out for you.

[jwiles]

Not with the join stage.

What would/needs to happen if there is more than one row in T2 with column a = 0?
Is the row with 0 meant to be a "default" value for c if there is no match on a?

Regards,

[manoj_23sakthi]

Hi,
In T2 it won't have more than one value as default.
yes it like default value if it not match.

[chulett]

So... what's your workaround?