title: Datastage: how to improve the performance load data from oracle to sql server
body: <p>The platform is <code>IBM Datastage 8.1 RHEL4 16G MEM,4CPU16CORE</code>. When I try to create a job to load data from Oracle to SQL Server the job is running correctly, but slowly. The row count from the source table in Oracle is about 100,000,000 and the speed load is only 620/s. </p>
  
  <p><strong>How can i improve the load speed in this job?</strong></p>
  
  <p>The flow is below:</p>
  
  <pre><code>oracle EE stage --&gt;  odbc stage [config the sqlserver odbc in .odbc.ini]
  </code></pre>
  
  <p>The odbc config:</p>
  
  <pre><code>Driver=/opt/IBM/InformationServer/Server/branded_odbc/lib/VMmsss23.so
  IANAAppCodePage=113
  Description=DataDirect SQL Server Wire Protocol driver
  Database=test
  LogonID=datastage
  Password=datacenter
  Address=127.1.2.3,1433
  QuotedId=No
  AnsiNPW=No
  </code></pre>