scenario: Insert   the records  of those employees who  have joined  in current month  and Reject other rows.

Source

E_NO       JOIN_DATE
    -------       ---------
      1        07-JUL-11
      2        05-JUL-11
      3        05-MAY-11
If the current month is july ,2011 then target  will be like this.

Target
   E_NO      JOIN_DATE
   -------       ---------
     1        07-JUL-11
     2        05-JUL-11

To insert current month records we have to follow these steps

 

  1. Connect one update strategy transformation next to SQF.
  2. In update strategy properties write the condition like this
  3. Send required ports update strategy to target.

I appreciate your comments