abha.sinha

 Profile Answers by abha.sinha 

• May 5th, 2009

 

Update Strategy can be used whenever we need to update some existing value in database. For an update strategy we need to have a primary key.

NOTNULL

 Profile Answers by NOTNULL 

• May 18th, 2009

 

Update transformations how to treat the data within the transformation means normally insertion will take place in the Informatica. If you update or delete means treat the data differently we use update strategy transformations

Like dd_insert (not mandatory)
dd_update (for updation)
dd_delete (for deletion)

pooja.verma

 Profile Answers by pooja.verma 

• Jun 2nd, 2009

 

Its always performance friendly to use Update strategy than informatica "Update else Insert" session target property.

sahan

 Profile Answers by sahan 

• Jul 16th, 2009

 

You can use the update strategy transformation when you want to update the existing values in the target. For this you need a primary key in the target.

seerum

 Profile Answers by seerum 

• Jul 16th, 2009

 

If you want to perform insert, update, delete based on some conditional clause then you can choose this and when it is not possible for other types of update procedures in Informatica. (necessary condition is target should have a primary key.)

chiranjoydas

 Profile Answers by chiranjoydas 

• Jul 29th, 2009

 

Update Strategy is used in case fo Updating a record if the same exists in the table. For that we need to have a primary key in the Informatica level even if the same is not present in database level. If no key is defined we need to use 'update override' in the target. Also when using this transformation click the 'Data Driven' property in the Session.

itisanimesh

 Profile Answers by itisanimesh 

• Aug 6th, 2009

 

Update strategy transformation is an Active and Connected transformation. It is used to update data in target table, either to maintain history of data or recent changes. You can specify how to treat source rows in table, insert, update, delete or reject

subbarao_mvs

 Profile Answers by subbarao_mvs 

• Oct 3rd, 2009

 

Update Strategy is an active and connected. Generally we use update strategy before target. To Insert or update or delete or reject rows coming from the source to target. The constants we use in update strategy transfromation are:

DD_INSERT  OR 0 --> INSERTING ROWS
DD_UPDATE OR 1 --> UPDATING ROWS
DD_DELETE  OR 2 --> DELETING ROWS
DD_REJECT  OR 3 --> REJECTING ROWS

nitijosh

 Profile Answers by nitijosh 

• Nov 23rd, 2009

 

We use update strategy when we need to alter the Database Operation (Insert/Update/Delete) based on the data passing through and some logic. Update Strategy alllows us to Insert (DD_INSERT) , Update (DD_UPDATE) and Delete (DD_Delete) based on logic specified in the Update Strategy condition field.
For update strategy to come into effect we must set a session level property "Treat Source As " user defined.

itjmn

 Profile Answers by itjmn 

• Apr 12th, 2010

 

Update strategy transformation is used not only to update the existing row/s but it can also be used to update a table by in serting news rows, deteting rows or updating the existing row or deleting the row in to the table.

In addition to the four constants like DD_Update, DD_Insert, DD_Delete,DD_Reject, we must also set the session property - Treat  Source Rows as -- "DATA DRIVEN"
If you do not choose Data Driven when a mapping contains an Update Strategy or Custom Transformation, the Workflow Manager display a warning.  When you run the  session, the Integration Service does not  follow instructions in the UPS to determine  how to flrag the rows, hence fails the session.

Infatech

 Profile Answers by Infatech 

• Apr 14th, 2010

 

By Default all the rows entering the Integration Service are marked as Insert.
But if you want to flag rows based on business logic for update or delete or insert, then you have to use Update Strategy

ram_infa

 Profile Answers by ram_infa Questions by ram_infa

• Sep 12th, 2011

 

The main of update strategy transformation is to maintain the history and current changes in the target table

ankit

• May 4th, 2016

 

Can any one tell me in which scenario it is not advisable to use update strategy?

Anil

• Jun 22nd, 2016

 

If we want to perform 2 DML operations but same operations it is not better to use update tr. use property in session (treat source rows as) instead of creating update tr.

If we want to perform 2 DML operations but different operations it is better to use update tr. in mapping level and specify operation to be performed. (treat source rows as data driven)