Tuesday, January 14, 2014

Update Strategy TransformationUpdate 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