Upsert vs. Merge statement in DB2, Oracle
Posted: Wed Jan 30, 2008 1:57 am
Hi,
I want to evaluate the option of inserting/Updating records in database (DB2 or Oracle) using Upsert or User defined Merge statement.
I am not going to use the Orchastrate.col_name as it hinders the performance...I have staging table created in the databse with which I'll call the merge statement.
Looking at this scenario, can someone suggest me which one to use & why..
I have fairly low volumetric around 50K with % increament of 5% every year.
Thanks & Regards
Sudeep
I want to evaluate the option of inserting/Updating records in database (DB2 or Oracle) using Upsert or User defined Merge statement.
I am not going to use the Orchastrate.col_name as it hinders the performance...I have staging table created in the databse with which I'll call the merge statement.
Looking at this scenario, can someone suggest me which one to use & why..
I have fairly low volumetric around 50K with % increament of 5% every year.
Thanks & Regards
Sudeep