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.
How to improve the performance in Server Job
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 1
- Joined: Wed Oct 11, 2006 2:50 am
How to improve the performance in Server Job
Last edited by kottaichamy100 on Wed Apr 04, 2007 12:56 am, edited 1 time in total.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
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.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.