title: Informatica Workflow shows different number of records in transformation and target
body: <p>Hi I am a informatica newbie trying to train myself in power center workflows.</p>
  
  <p>when I look at many of the workflow last sessions runs in the workflow monitor I see the number of records that are picked by the transformation is different than the number of records that get updated or inserted in the target table.</p>
  
  <p>in the below image for example my sql transformation picks 80,742 rows from the source table. but only 29,813 rows get loaded into the target table.</p>
  
  <p><a href="http://imgur.com/4QzsLwm" rel="nofollow">image of informatica workflow monitor</a></p>
  
  <p>on further analyzing the workflow log file I can see it loaded both insertable records and updatable records:</p>
  
  <blockquote>
    <p>WRT_8036 Target: W_SALES_ORDER_LINE_F (Instance Name:
    [W_SALES_ORDER_LINE_F]) WRT_8038 Inserted rows - Requested: 15284<br>
    Applied: 15284      Rejected: 0          Affected: 15284      WRT_8041
    Updated rows  - Requested: 14529      Applied: 14529      Rejected: 0 
    Affected: 14529     </p>
    
    <p>WRITER_1_*_1> WRT_8035 Load complete time: Wed Mar 19 04:41:24 2014</p>
  </blockquote>
  
  <p>I am not able to figure out why would the workflows load lesser records than what source sql gives. and I would really appreciate some help in this matter.</p>
  
  <p>Thanks,
  Matt</p>