DSXchange

Hi,

Is there a single stage in DS that performs the same actions as of Oracle Merge.

Basically, I have two input datastreams and one output stream and I have to perfrom a LEFTOUTER join, but I dont want to use a downstream transformer for the logic ( If NUll(reference.value) then out.value = primary.value else reference.value ).

I just want to update a primary set with updates. but would like to keep the originals when there are no updates.

Can we do it in a single stage?

How about join stage?

This is still open. I am just wondering if the CDC & A stages can be used, but in CDC I am not able to propogae columns of Before dataset. Any other stages, that avoids transformer