Sunday, January 20, 2013

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

No comments:

Post a Comment

Thank you :
- kareem