Sunday, December 16, 2012

Insert and reject records using update strategy.


Scenario: There is a emp table and from that table insert the data to target where sal<3000 and="" o:p="" other="" reject="" rows.="">
Following are the steps for achieving it
  1. connect out-puts from SQF to Update Strategy transformation.






  1. In properties of  Update Strategy write the condition like this
  2. Connect the Update Strategy to target


1 comment:

Thank you :
- kareem