DSXchange

I am using server job to transfer data from SQL Server to mainframes. But it is taking more time say 3 minutes for inserting 1500 records where as same job having target as Oracle is taking only 30 seconds to transfer the same number of records.Is it because connecting to mainframes takes more time or is there any way to improve the performance?

Server Edition : Datastage 7.5

Welcome aboard. :D

The key performance indicator in ETL is elapsed time. If you can get the data in - or out, as the case may be - within the allowed time window, with a safety margin, then your ETL is performing satisfactorily.

Obviously there are going to be obstacles when transferring data to different platforms. You would probably encounter similar obstacles if the target were, for example, an AS/400.