title: Pentaho Data Integration Kettle - Why when one record is updated it appears as if two records are updated?
body: <p>I am using Pentaho Data Integration Kettle and SQL Server and have already made a Data Warehouse, but there is something I don't understand. When I update a record on a dimension it appears as if two records were updated, although it only updated one as it should.</p>
  
  <p>First I extract from CSV file, then select and rename values, then look up for another dimension surrogate key and then lookup/update dimension with punch through. (SCD Type 1)</p>
  
  <p><a href="https://i.stack.imgur.com/gqcZM.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/gqcZM.png" alt="Pentaho ETL transformation"></a></p>
  
  <p>After updating just 1 record:</p>
  
  <p><a href="https://i.stack.imgur.com/XprX0.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/XprX0.png" alt="Pentaho duplicate in Log"></a></p>
  
  <p>Why?</p>
  
  <p>Thank you!</p>