Skip Ribbon Commands
Skip to main content
Navigate Up
Sign In

Quick Launch

Average Rating:

(1 Rating)
facebook Twitter
Print Bookmark Alert me when this article is updated


HOW TO: Extract records which do not satisfy a join condition using a Joiner transformation in a PowerCenter Mapping

To extract records out of the Joiner transformation, do the following:

  1. Select either the Detailed Outer Join, Master Outer Join or Full Outer Join for the Joiner transformation Join Type
  2. Filter out the records that met the join condition.


For a master Source Definition ( TableA ) and a detail Source Definition (TableB) with key columns do the following:

  1. Enter a Join condition as TableA.key = TableB.key.
  2. Select the Detail Outer Join as the Join Type.
  3. Then, using a Filter or Router transformation enter the following for the ( Group ) Filter Condition :


  4. Records that meet this condition can be sent to a target table or file.
More Information
Applies To
Product: PowerCenter
Problem Type:
User Type: Administrator
Project Phase:
Product Version: PowerCenter
Operating System:
Other Software:
Last Modified Date:9/11/2013 6:05 AMID:17166
People who viewed this also viewed


Did this KB document help you?

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