How to improve the performance in Server Job

kottaichamy100 · Post by **kottaichamy100** » Wed Mar 28, 2007 5:42 am

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.

srinagesh · Post by **srinagesh** » Wed Mar 28, 2007 6:32 am

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..

ray.wurlod · Post by **ray.wurlod** » Wed Mar 28, 2007 7:05 am

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.

chulett · Post by **chulett** » Wed Mar 28, 2007 7:08 am

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.