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
Performance improvement
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 1
- Joined: Sun Mar 25, 2007 4:13 am
- Location: Chennai
Performance improvement
Maheedhar k
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
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.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.