Transformation Guide

Back Next

Example of a Join Condition

For example, 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 Integration Service fails the session.

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

Watch

Comments

0 COMMENTS

We’d like to hear from you! Log in to comment.