Skip Ribbon Commands
Skip to main content
Navigate Up
Sign In

Quick Launch

Average Rating:

facebook Twitter
Email
Print Bookmark Alert me when this article is updated

Feedback

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

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:

TC_COMMIT_AFTER

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.

Reference
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
Database:
Operating System:
Other Software:
Attachments
Last Modified Date:5/17/2011 5:09 AMID:15652
People who viewed this also viewed

Feedback

Did this KB document help you?



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