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.
------- ---------
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
E_NO JOIN_DATE
------- ---------
1 07-JUL-11
2 05-JUL-11
To insert current month records we have to follow these steps
- Connect one update strategy transformation next to SQF.
- In update strategy properties write the condition like this
- Send required ports update strategy to target.
No comments:
Post a Comment
Thank you :
- kareem