Ascential Datastage 7.5 Server Job Performance Issue
Posted: Sun Sep 14, 2008 6:44 pm
Hi,
Can anyone please help me out in solving the performance issue in the my job structure.
I have a big problem in extracting 30milion records from sysbase server and load it into the target database which is db2.
The datastage is on AIX server and we are using server jobs.
Can anyone suggest me how to increase the performance of extraction and loading. Present time taken is about 12hrs.
FYI there are inserts and updates in the target database.
Thanks a lot in advance.
Can anyone please help me out in solving the performance issue in the my job structure.
I have a big problem in extracting 30milion records from sysbase server and load it into the target database which is db2.
The datastage is on AIX server and we are using server jobs.
Can anyone suggest me how to increase the performance of extraction and loading. Present time taken is about 12hrs.
FYI there are inserts and updates in the target database.
Thanks a lot in advance.