title: Performance bottleneck at target in informatica mapping
body: <p>I have a informatica mapping wherein soft delete condition is as follows:</p>
  
  <pre><code>Pk_Src is null and Pk_Tgt is not null then set the active_flag to N.
  </code></pre>
  
  <p>Now based on this condition the mapping evaluated that there are 400k records which needs to be updated. Its a simple update but it is taking more than 3 hours using update strategy </p>
  
  <p>Appreciate your valuable inputs.</p>
  
  <p>Dex.</p>