August 2017
Beginner to intermediate
426 pages
9h 36m
English
Transaction Control transformation allows you to commit or rollback individual records based on a certain condition. By default, Integration service commits the data based on the properties you define at the session task level. Using the Commit Interval property, Integration service commits or rolls back the data into the target. Suppose you define the Commit interval as 10,000, Integration service will commit the data after every 10,000 records. When you use Transaction Control transformation, you get the control at each record to commit or rollback.
When you use Transaction Control transformation, you need to define the condition in the expression editor of the Transaction Control transformation. When ...
Read now
Unlock full access