what is update strategy transformation ?

The model you choose constitutes your update strategy, how to handle changes to existing rows. In PowerCenter and PowerMart, you set your update strategy at two different levels:

• Within a session. When you configure a session, you can instruct the Informatica Server to either treat all rows in the same way (for example, treat all rows as inserts), or use instructions coded into the session mapping to flag rows for different database operations.
• Within a mapping. Within a mapping, you use the Update Strategy transformation to flag rows for insert, delete, update, or reject.

Chrees,

Sithu

  1 User has rated as useful.

  

Login to rate this answer.

Update strategy transformation is used for flagging the records for insert,
update, delete and reject

In Informatica power center u can develop update strategy at two levels

use update strategy T/R in the mapping design

target table options in the session

the following are the target table options

Insert

Update

Delete

Update as Insert

Update else Insert

Thanks,

Rekha