Database Reference
In-Depth Information
Transaction Control transformations
Transaction Control transformations allow you to commit or roll back individual records
based on certain conditions. By default, Integration Service commits the data based on the
properties you define at the session task level. Using the
Commit Interval
property, Integ-
ration Service commits or rolls backs the data into the target. Suppose you define
Commit
Interval
as
10,000
, Integration Service will commit the data after every 10,000 records.
When you use a Transaction Control transformation, you get the control at each record to
commit or roll back.
When you use the Transaction Control transformation, you need to define the condition in
the expression editor of the Transaction Control transformation. When you run the process,
the data enters the Transaction Control transformation in a row-wise manner. The Transac-
tion Control transformation evaluates each row, based on which it commits or rolls back
the data.
A sample mapping using the Transaction Control transformation is shown in the following
screenshot:
To use the Transaction Control transformation in the mapping, perform the following steps:
1. Open the mapping in Mapping Designer and create the Transaction Control trans-
formation.
2. Drag the required columns from the Source Qualifier transformation to the Trans-
action Control transformation.
3. Connect the appropriate ports from the Transaction Control transformation to the
target.
