Need to Update and insert at the same time

[prasanna2802]

Hi ,
I have a req for
For a customer C1 ,which is already present in the target table
and when the same customer C1 comes in with some change in attribute.

i need to
Update the existing C1 record (changing the EFF_DT and the EXP_DT) AND
Inserting a new row as C1 with new eff_dt and exp_dt.
Can we acheive this using the oracle connector PX?

[ray.wurlod]

Welcome aboard. Presumably the decision is made in your job logic. Best practice is to use two Connectors - one to handle the inserts and one to handle the updates. To avoid deadlocks, hold one or the other to a Data Set and move those records into the table in a subsequent job.