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
Perform join with OR condition
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 47
- Joined: Tue Feb 23, 2010 12:16 am
- Location: CHENNAI
Re: Perform join with OR condition
Why not? All you need to do is click on Post new topic anywhere in the appropriate forum to start a new post.manoj_23sakthi wrote:Hi
sorry for this..
I am not able to post this in new post.
Split out for you.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Participant
- Posts: 47
- Joined: Tue Feb 23, 2010 12:16 am
- Location: CHENNAI