Search found 1 match
- Thu Jan 29, 2009 1:55 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Merging two tables to speedup Insert/update which is slower
- Replies: 1
- Views: 745
Merging two tables to speedup Insert/update which is slower
All, I have 2 tables located in same database in different schema and we are merging(insert and update based on keys)one table with other.Merge is getting slower day by day as volume increases in DataMart. This merge is the replacement of requirement.. 1.Extract from Source store in Staging area and...