DSXchange

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.

You can find lots of tips on Performance improvement by using the Search facility.

There are tips like setting the Buffer Size, modifying the job design, partitioning the table etc etc..

Manage expectations better. This might be the best achievable time - it depends on very many things, such as the complexity of transformations, the number of indexes and constraints on the target table and, of course, the efficiency of your ETL design.

Without knowing those factors it is impossible to advise. If you post details of your ETL design (for example how you are effecting the lookups), then we may be able to help at least in the ETL design milieu.

We'd need more details to give any meaningful advice. How about as complete of a description of your job as you can manage? That should get us started.