Specifying Update Options for Individual Targets
After you use an Update Strategy transformation to flag each row for a particular database operation, define insert, update, and delete options for each target in the mapping. You can disallow inserts or deletes for rows flagged for insert or delete. You can choose different ways to handle updates for all rows flagged for update.
Define the update strategy options in the Advanced properties of a target data object in a mapping. You can set the following update strategy options:
- Insert
- Inserts all rows flagged for insert into a target. Default is enabled.
- Delete
- Deletes all rows flagged for delete from a target. Default is enabled.
- Update Strategy
Update strategy for existing rows. Select one of the following strategies:
- - Update as Update. Updates all rows flagged for update. This is the default value.
- - Update as Insert. Inserts all rows flagged for update.
- - Update else Insert. Updates all rows flagged for update if they exist in the target and then inserts any remaining rows marked for insert.
- Truncate Table
- Truncates the target before loading data. Default is disabled.