I am in the process of switching from Oracle OCI stages to Oracle Connector stage in my SERVER jobs. I have come across a difference in the way the Connector stage handles rows with a duplicate key. I would like the Connector to work the same as the OCI stage.
The OCI stage throws a duplicate key warning, but continues to process and insert all the other rows. My desired result.
In the Connector stage, if I have Write Mode set to Insert no rows are inserted after a duplicate key is found. If Write Mode is set to Insert New Rows Only, then the non duplicate rows are written but DS does not throw any warnings.
In every case I have Array Size = 1000 and Record Count = 0
Is there a way to set the Oracle Connector stage to give warnings for rows with errors and insert rows without warnings?
Issue switching from Oracle OCI to Connector in Server job
Moderators: chulett, rschirm, roy