sithusithu

 Profile Answers by sithusithu 

• Jan 19th, 2006

 

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

chandrarekha

• Sep 12th, 2007

 

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