How to increase the performance of the job
Posted: Tue Mar 25, 2008 11:30 am
Hi Everyone,
I have developed a job, which select records from table and inserts into other table.
Here the source is sqlserver in one location and target is Informix on unix in different location.I have used ODBC stage for both source table and target table. I have transformer stage for mapping the columns. Currently it is taking 20 mins to load 32000 records.
If i do the same test with the source database and target database are in the same location it is taking not more than 25 secs to load the same data.
There are indexes and keys on the target side.
My DBA did the same test by loading the same data in the informix database which is on different location through FTP. It took 25 secs to load the same data. But why is it taking 20 mins if i load the same data through datastage job.
I guess there is lot of difference in the performance.I want to increase the performance of this job. So that it loads data with greater speed.
Please suggest me some tips to increase the performance of this job.
Thanks,
I have developed a job, which select records from table and inserts into other table.
Here the source is sqlserver in one location and target is Informix on unix in different location.I have used ODBC stage for both source table and target table. I have transformer stage for mapping the columns. Currently it is taking 20 mins to load 32000 records.
If i do the same test with the source database and target database are in the same location it is taking not more than 25 secs to load the same data.
There are indexes and keys on the target side.
My DBA did the same test by loading the same data in the informix database which is on different location through FTP. It took 25 secs to load the same data. But why is it taking 20 mins if i load the same data through datastage job.
I guess there is lot of difference in the performance.I want to increase the performance of this job. So that it loads data with greater speed.
Please suggest me some tips to increase the performance of this job.
Thanks,