Skip Ribbon Commands
Skip to main content
Navigate Up
Sign In

Quick Launch

Average Rating:

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

Feedback

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

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.

Reference
Applies To
Product: PowerCenter
Problem Type:
User Type: Administrator
Project Phase:
Product Version: PowerCenter; PowerCenter 8.x; PowerCenter 9.x
Database:
Operating System:
Other Software:
Attachments
Last Modified Date:10/13/2011 10:53 PMID:15923
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)