Equivalent of ORACLE MERGE in Datastage

bikan · Post by **bikan** » Mon Nov 05, 2007 7:21 am

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?

Maveric · Post by **Maveric** » Mon Nov 05, 2007 7:23 am

How about join stage?

bikan · Post by **bikan** » Tue Nov 06, 2007 2:47 am

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