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 an Aggregator transformation be placed downstream of a "transaction control" transformation within a mapping?
Answer
You can place an Aggregator downstream of a transaction control transformation in a PowerCenter mapping. To do this, set the transformation scope of the Aggregator transformation to transaction.

More Information
The default transformation scope of an Aggregator transformation is all input. If this setting is not updated to transaction, then transaction boundaries will be dropped by the Aggregator and the upstream transaction control transformation becomes effectively redundant.

Applies To
Product: PowerCenter
Problem Type:
User Type: Administrator
Project Phase:
Product Version: PowerCenter
Database:
Operating System:
Other Software:

Reference

"Transaction Control Transformation" in PowerCenter 8.6.1 Transformation Guide


Attachments

Last Modified Date:6/10/2009 2:54 AMID:106106
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)