- PowerCenter 10.1.1
- All Products
Rows As Option
Integration Service marks all rows to insert into the target.
Integration Service marks all rows to delete from the target.
Integration Service marks all rows to update the target. You can further define the update operation in the target options.
Integration Service uses the Update Strategy transformations in the mapping to determine the operation on a row-by-row basis. You define the update operation in the target options. If the mapping contains an Update Strategy transformation, this option defaults to Data Driven. You can also use this option when the mapping contains Custom transformations configured to set the update strategy.