Developer Transformation Guide

Back Next

Example of a Join Condition and Sort Order

This example shows a Joiner transformation that join the master and detail pipelines with sorted ports.

You configure Sorter transformations in the master and detail pipelines with the following sorted ports:

ITEM_NO

ITEM_NAME

PRICE

When you configure the join condition, use the following guidelines to maintain sort order:

You must use ITEM_NO in the first join condition.

If you add a second join condition, you must use ITEM_NAME.

If you want to use PRICE in a join condition, you must also use ITEM_NAME in the second join condition.

If you skip ITEM_NAME and join on ITEM_NO and PRICE, you lose the sort order and the Data Integration Service fails the mapping run.

The following figure shows a mapping configured to sort and join on the ports ITEM_NO, ITEM_NAME, and PRICE:

When you use the Joiner transformation to join the master and detail pipelines, you can configure any one of the following join conditions:

ITEM_NO = ITEM_NO

ITEM_NO = ITEM_NO1

ITEM_NAME = ITEM_NAME1

ITEM_NO = ITEM_NO1

ITEM_NAME = ITEM_NAME1

PRICE = PRICE1