Same as previous scenario, here target records has to be deleted if corresponding record gets deleted in source
mapping:
Joiner Transformation:
1. Target table as Master
2. Join Type : Detail Outer Join
3. Condition : EMPNO_SRC = EMPNO_TGT
Update Strategy:
Update Strategy Expression: IIF(ISNULL(EMPNO),DD_DELETE,DD_REJECT)
1. Target table as Master
2. Join Type : Detail Outer Join
3. Condition : EMPNO_SRC = EMPNO_TGT
Update Strategy:
Update Strategy Expression: IIF(ISNULL(EMPNO),DD_DELETE,DD_REJECT)
No comments:
Post a Comment