In real time scenario where update strategy transformation is used?if we dml operations in session properties then what is the use of update strategy transforamtion ?

Questions by narendranathyogi

Showing Answers 1 - 4 of 4 Answers

Rangini vignesh

  • Aug 29th, 2006
 

Ans:We can use Update strategy transformation in two ways .

1.Mapping level.

2.session level.

Importence of Update strategy transformation in both cases as follows.

In real time if we want to update the existing record with the same source data you can go for session level update logic.

If you want to applay different set of rules for updating or inserting a record,even that record is existed in the warehouse table .you can go for mapping level Update strategy transformation.It means that if you are using Router transformation for performaning different activities.

EX: If the employee 'X1234 ' is getting Bonus then updating the Allowance with 10% less.If not, inserting the record with new Bonus in the Warehouse table.

  Was this answer useful?  Yes

Noel Lastra

  • Feb 22nd, 2007
 

Update strategy, Supposed you have a router you are router has 3 groups, 1 group is for update, 1 group is for delete, 1 group is for insert to target table.  You can use the update strategy for each group before going to target and changing the expression to DD_UPDATE, DD_DELETE, and DD_Insert.  Don't forget to change the session property, treat source rows as (something like this) DATA_DRIVEN.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions