Upsert vs. Merge statement in DB2, Oracle

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
sudeepmantri
Participant
Posts: 54
Joined: Wed Oct 25, 2006 11:07 pm
Location: Hyderabad

Upsert vs. Merge statement in DB2, Oracle

Post by sudeepmantri »

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
Top
Post Reply

Return to “IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)”