Scenario:There is a emp table and from that table insert the data to targt where sal<3000 and reject other rows.
Following are the steps for achieving it
- connect out-puts from SQF to Update Strategy transformation.
- In properties of Update Strategy write the condition like this
- Connectthe Update Strategy to target
If you have any better way to solve this, don't forget to comment