title: Does Ab Initio support Oracle Merge statement?
body: <p>Am attempting to design an Ab Initio load process without any Ab Initio training or documentation. Yeah I know.
  A design decision is: for the incoming data files there will be inserts and updates.
  Should I have the feed provider split them into to data files (1 - 10 GB in size nightly) and have Ab Initio do inserts and updates separately?   </p>
  
  <p>A problem I see with that, is data isnt always what you expect it to be...
  And an Insert row may be already present (perhaps purge failed or feed provider made a mistake)
  Or UPdate row isnt present.</p>
  
  <p>So I'm wondering if I should just combine all inserts and updates... and use Oracle Merge statement 
  (after parallel loading the data into a staging table with no index of course)</p>
  
  <p>But I don't know if AbInitio supports Merge or not.</p>
  
  <p>There is not much for ab initio tutorials or docs on web... can you direct me to anything good?</p>