This isn't possible in a single stage, you'd need to have determined the logic ahead of DB operations and route accordingly with different update keys and requirements to seperate stages.
Mark Winter
<i>Nothing appeases a troubled mind more than <b>good</b> music</i>
Can't say if it is useful in your scenario, but you can use case statement in update query. and passing a flag from an upstream transformer can reduce the complexity.
I am not sure if you can put a case statement as argument of SET but you can give it a shot.
Else you can go for miwinter's suggestion.
Priyadarshi Kunal
Genius may have its limitations, but stupidity is not thus handicapped.
Of course you can use a single stage, it's a single link you can't use. Just create a link for each combination needed and send your data down the correct one.
-craig
"You can never have too many knives" -- Logan Nine Fingers
Oracle stages must work differently to others then. As for DB2, you can't assign more than one stream input to it. Unless the OP should have actually posted in the correct forum.
Last edited by miwinter on Wed Jun 10, 2009 7:22 am, edited 1 time in total.
Mark Winter
<i>Nothing appeases a troubled mind more than <b>good</b> music</i>
Perhaps. Note that this is a Server answer, in which the OCI stage allows multiple inputs, it just means they must all connect to the same instance. PX doesn't allow it, however.
-craig
"You can never have too many knives" -- Logan Nine Fingers
Well, it is marked as a Server job in the original post and more people tend to get that right than to post in the correct forum, it seems. We'll have to see what Gokul says.
-craig
"You can never have too many knives" -- Logan Nine Fingers
