title: Update strategy for table with sequence generated number as primary key in Informatica
body: <p>I have a mapping that gets data from multiple sql server source tables and assigns a sequence generated number as ID for each rows. In the target table, the ID field is set as primary key.</p>
  
  <p>Every time I run this mapping, it creates new rows and assigns a new ID for the records that are pre-existing in the target. Below is an example:</p>
  
  <pre><code>1st run:
  ID   SourceID   Name   State
  1     123        ABC   NY
  2      456       DEF   PA
  
  2nd run:
  ID   SourceID   Name   State
  1     123        ABC   NY
  2      456       DEF   PA
  3     123        ABC   NY
  4      456       DEF   PA
  </code></pre>
  
  <p>Desired Output must:
  1)  create a new row and assign a new ID if a record gets updated in the source. 
  2) create a new row and assign a new ID if new rows are inserted in the source.</p>
  
  <p>How can this be obtained in Informatica?</p>
  
  <p>Thank you in advance!</p>