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


FAQ: Can duplicate rows be eliminated when using a Union transformation in a PowerCenter mapping?

To eliminate duplicates rows when using a Union transformation add an Aggregator Transformation or Sorter Transformation (with the Distinct option) after the Union Transformation.

More Information

A feature request (CR 88555) has been created to add the option to either discard or retain the duplicates in the Union Transformation.

Applies To
Product: PowerCenter
Problem Type:
User Type: Administrator
Project Phase:
Product Version: PowerCenter; PowerCenter 8.x; PowerCenter 9.x
Operating System:
Other Software:
Last Modified Date:10/13/2011 10:53 PMID:15923
People who viewed this also viewed


Did this KB document help you?

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