title: Missing data while loading data through ETL datastage
body: <p>I am trying to load data from DB2 table to Netezza through ETL Datastage. This is a delta load against a timestamp column.
  So source SQL is like</p>
  
  <pre><code>select * from db2_table where timestamp_column &gt; '2017-02-10 08:24:00';
  </code></pre>
  
  <p>After loading data in Netezza table, when I ran below query and got following result.</p>
  
  <pre><code>select max(timestamp_column) from netezza_table; 
  </code></pre>
  
  <p>returns <code>'2017-02-10 11:17:56'</code></p>
  
  <p>Which looks good to me.</p>
  
  <p>But I have noticed that we have a record in the DB2  table whose timestamp_column is <code>'2017-02-10 11:17:54'</code>, though that data is missing in destination Netezza table.</p>
  
  <p>This is not a regular issue, but when the issue occurred, I have noticed that missing record's <code>timestamp_column</code> value is less than 1 or 2 second.</p>
  
  <p>My question is, if <code>max(timestamp_column)</code> value is <code>'2017-02-10 11:17:56'</code> in Netezza then the ETL job should have fetched the <code>'2017-02-10 11:17:54'</code> record. </p>
  
  <p>How it is possible to miss this record?</p>