Skip Ribbon Commands
Skip to main content
Navigate Up
Sign In

Quick Launch

Average Rating:

facebook Twitter
Print Bookmark Alert me when this article is updated


FAQ: Can a PowerCenter mapping be configured to commit target data on every row?

To configure a PowerCenter mapping to commit target data on every row add a Transaction Control Transformation (TCT) to the mapping before the target with the following expression:


This will commit after every record sent to the target, regardless of the buffer block size or target commit interval.

More Information

Doing this is generally not recommended as it will adversely affect performance. One of the most common reasons to implement this is when there are duplicate rows in the source.

For a more effective and efficient ways to do this refer to the related articles.

PowerCenter Transformation Guide > "Transaction Control Transformation" > "Transaction Control Transformation Properties"

PowerCenter Transformation Language > "Variables" > "Transaction Control Variables"

Applies To
Product: PowerCenter
Problem Type:
User Type: Developer
Project Phase:
Product Version: PowerCenter
Operating System:
Other Software:
Last Modified Date:5/17/2011 5:09 AMID:15652
People who viewed this also viewed


Did this KB document help you?

What can we do to improve this information (2000 or fewer characters)