Posted: Fri Oct 20, 2006 12:47 am
Try to monitor the CPU usage of your server when you run this job. For initial load (or atleast for testing) change the update action to Insert and drop indeces in the target table (if you have any) before loading the data.
If you database and datastage are of different server, check for network congestion as well.
If you database and datastage are of different server, check for network congestion as well.