Oracle Connector with Insert Else Update
Posted: Mon May 09, 2011 6:15 am
Hi,
Am using Oracle connector stage with load method as 'Insert Else Update'.
but the amount of data for Update will be much bigger and higher than Inserts. Because of my 'Insert Else Update' load method, job takes atleast 3 hours to update 0.3 million records.
If I use 'update else Insert', job pops out 'Unique key violation error' and if I turn it ot 'Insert Else Update', it works fine but very degraded performance.
Please share your thoughts to overcome this performance issue or suggest me any alterantives to manage this.
Thanks in advance.
Am using Oracle connector stage with load method as 'Insert Else Update'.
but the amount of data for Update will be much bigger and higher than Inserts. Because of my 'Insert Else Update' load method, job takes atleast 3 hours to update 0.3 million records.
If I use 'update else Insert', job pops out 'Unique key violation error' and if I turn it ot 'Insert Else Update', it works fine but very degraded performance.
Please share your thoughts to overcome this performance issue or suggest me any alterantives to manage this.
Thanks in advance.