Update Strategy Transformation in
Informatica , is a
connected and active transformation.Update Strategy transformation let you insert, update , delete data from target Data also. It can also reject the incoming data depending upon your condition.
For example : when a customer is changing address , you can use this update strategy transformation to update data in your Customer Tables. In below article we will go through the properties of
Update Strategy Transformation. We will also discuss the
steps of adding /configuring Update Strategy transformation in
Informatica Mapping
You can define update operation on below two levels:
Update Strategy on Session level:
We can instruct Informatica Service to treat all rows in the same way or use same instruction by configuring Target mapping at session level.
Update Strategy on Mapping level:
You can flag a row (for insert , update, delete or Reject depending upon some condition) by adding "Update strategy Expression" in the properties tab of Update Strategy Transformation in a Mapping. Below Flags can be set in Update strategy Expression.
Flag |
Numeric Value |
Type Operation |
DD_INSERT |
0 |
Insert row |
DD_UPDATE |
1 |
Update row |
DD_DELETE |
2 |
Delete row |
DD_REJECT |
3 |
Reject row |
For more details on Update Transformation , Please check
here
A well explained example can be found
here as well.
No comments:
Post a Comment