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?
Equivalent of ORACLE MERGE in Datastage
Moderators: chulett, rschirm, roy
Equivalent of ORACLE MERGE in Datastage
Last edited by bikan on Mon Nov 05, 2007 7:26 am, edited 1 time in total.