Upsert in Oracle
Posted: Tue Dec 21, 2010 8:49 am
Hi,
I need to perform upsert in a table using User defined SQL.
My design is:
Dataset----> CPY ----> Oracle Enterprice.
For example my update query is:
UPDATE Tablename set columnname = ORCHESTRATE.columnname where ROW_ID= ORCHESTRATE.ROW_ID
I need to update for some 100000 records. This takes very long time i.e 2 records per second.
Can I get any solution for this?
Note: The insert, and other loading jobs are running fast except this upsert.
I need to perform upsert in a table using User defined SQL.
My design is:
Dataset----> CPY ----> Oracle Enterprice.
For example my update query is:
UPDATE Tablename set columnname = ORCHESTRATE.columnname where ROW_ID= ORCHESTRATE.ROW_ID
I need to update for some 100000 records. This takes very long time i.e 2 records per second.
Can I get any solution for this?
Note: The insert, and other loading jobs are running fast except this upsert.