Performance
Posted: Wed May 28, 2003 7:22 am
Hi All
I am new to datastage.I've designed a job which populates a table.It extracts the data from three different tables,90% of the rows come from a particular table.In the transformer stage I perform many substring functions on particular input column which feed the appropriate columns in the target.I also have two subroutines which feed the target column upon satisfying the particular condition.Now,my problem is,it is taking lot of time to load the target.When i monitor the transformer stage it shows 1 row/sec initially and after that it doesn't load for quite long time it took some 30 Hrs to load 3500 records.Can anyone please tell me the solution to improve the performance.
Thanks in advance.
Shivakumar
I am new to datastage.I've designed a job which populates a table.It extracts the data from three different tables,90% of the rows come from a particular table.In the transformer stage I perform many substring functions on particular input column which feed the appropriate columns in the target.I also have two subroutines which feed the target column upon satisfying the particular condition.Now,my problem is,it is taking lot of time to load the target.When i monitor the transformer stage it shows 1 row/sec initially and after that it doesn't load for quite long time it took some 30 Hrs to load 3500 records.Can anyone please tell me the solution to improve the performance.
Thanks in advance.
Shivakumar