Skip Ribbon Commands
Skip to main content
Navigate Up
Sign In

Quick Launch

Average Rating:

(2 Ratings)
facebook Twitter
Print Bookmark Alert me when this article is updated


"Concatenation disallowed on transformation" when attempting to link a port in a PowerCenter mapping
Problem Description
When attempting to link one port in one transformation to another transformation in a PowerCenter mapping, the link is not created and the following message appears:

Concatenation disallowed on transformation <Transformation_Name>.Message. Active transformations (<trans_name1, trans_name2>...)


This error occurs when attempting to connect an output from one transformation to another transformation that already has an input from another active transformation.
The error is a warning of a design mistake.

Each active transformation must be connected to separate transformations (including target) for the mapping to be valid.
For more detailed information refer to article 16229 below.
More Information


If one input to an Update Strategy, writes 100 rows, and another input writes 50 rows, the Update transformation will be unable to determine which row to update.

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

PowerCenter Designer Guide > 'Mappings" > "Connecting Mapping Objects" > "Rules and Guidelines for Connecting Mapping Objects"
Last Modified Date:6/29/2010 3:04 PMID:9149
People who viewed this also viewed


Did this KB document help you?

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