delayed insert

[babbu9]

Hi
I have question regarding SCD2. There are couple of delta records coming in from CDC. I have to expire (user defined update on the rec_exp_date column) the corresponding records first and insert new records (user defined insert) . My current job design is like this.


CDC--->Transformer------>Oracle update stage
|
V
Oracle insert stage

The problem is that the inserts are happening before the updates even after defining the link ordering in transformer. This is causing the records to be rejected due to primary key violation.I donot want to change the design much. Is there a condition that I can insert in the transformer so that the update can happen before the insert process.

Thanks
Babu

[chulett]

Use a single Oracle stage.