Why did u use update stategy in your application?

angeletteeye

Aug 8th, 2006

Update Strategy is used to drive the data to be Inert, Update and Delete depending upon some condition. You can do this on session level tooo but there you cannot define any condition.For eg: If you want to do update and insert in one mapping...you will create two flows and will make one as insert and one as update depending upon some condition.Refer : Update Strategy in Transformation Guide for more information

Guest

Aug 25th, 2006

Update Strategy is the most important transformation of all Informatica transformations.
The basic thing one should understand about this is , it is essential transformation to perform DML operations on already data populated targets(i.e targets which contain some records before this mapping loads data)
It is used to perform DML operations.
Insertion,Updation,Deletion,Rejection
when records come to this transformation depending on our requirement we can decide whether to insert or update or reject the rows flowing in the mapping.
For example take an input row , if it is already there in the target(we find this by lookup transformation) update it otherwise insert it.
We can also specify some conditions based on which we can derive which update strategy we have to use.
eg: iif(condition,DD_INSERT,DD_UPDATE)
if condition satisfies do DD_INSERT otherwise do DD_UPDATE
DD_INSERT,DD_UPDATE,DD_DELETE,DD_REJECT are called as decode options which can perform the respective DML operations.
There is a function called DECODE to which we can arguments as 0,1,2,3
DECODE(0) , DECODE(1) , DECODE(2) ,DECODE(3) for insertion updation deletion and rejection

satyaneerumalla
Profile Answers by satyaneerumalla Questions by satyaneerumalla

Aug 25th, 2006

Update Strategy is the most important transformation of all Informatica transformations.
The basic thing one should understand about this is , it is essential transformation to perform DML operations on already data populated targets(i.e targets which contain some records before this mapping loads data)
It is used to perform DML operations.
Insertion,Updation,Deletion,Rejection
when records come to this transformation depending on our requirement we can decide whether to insert or update or reject the rows flowing in the mapping.
For example take an input row , if it is already there in the target(we find this by lookup transformation) update it otherwise insert it.
We can also specify some conditions based on which we can derive which update strategy we have to use.
eg: iif(condition,DD_INSERT,DD_UPDATE)
if condition satisfies do DD_INSERT otherwise do DD_UPDATE
DD_INSERT,DD_UPDATE,DD_DELETE,DD_REJECT are called as decode options which can perform the respective DML operations.
There is a function called DECODE to which we can arguments as 0,1,2,3
DECODE(0) , DECODE(1) , DECODE(2) ,DECODE(3) for insertion updation deletion and rejection