Insert and reject records using update strategy.

                                                                                                                                                                      

Scenario:

Insert and reject records using update strategy.

There is an emp table and from that table insert the data to targt where sal<3000 and reject other rows.

Solution:

1.  connect out-puts from SQF to Update Strategy transformation.

2.  In properties of  Update Strategy write the condition like this
           IIF(SAL<3000,DD_INSERT,DD_REJECT)

3. Connectthe Update Strategy to target