Search found 1 match
- Wed Mar 28, 2007 5:42 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: How to improve the performance in Server Job
- Replies: 3
- Views: 1221
How to improve the performance in Server Job
Hi All, For a SCD Type -2 Server job, it is taking 1 hour 46 min to load data into Target. The details are No of i/p rows:2223745 rows, In Target For Update: 24353 rows,4rows/sec For Insert : 1448282 rows,262 rows/sec Can you please give any suggestions for improving performance of this job.