You can join detail trees with their detail records. However, joining imported trees with records is different than joining created tree source definitions with records.

You can join a detail tree that you import with its detail record in the Application Source Qualifier. The detail record contains values related to the detail ranges in a tree.

When you connect an imported detail tree and detail record in an Application Source Qualifier, the Designer creates a default join based on the detail ranges in the tree and the related column in the detail record. When the PowerCenter Integration Service performs the join, it produces a row for each value in the related column of detail record that matches or falls within the tree detail ranges. When the PeopleSoft tree references a detail value more than once, the PowerCenter Integration Service produces a row for each use of the detail value.

For example, the following data represents the detail tree pictured in Detail Trees and the Detail Record.

The following table displays the RANGE_FROM and RANGE_TO values for each row that represent the detail ranges in the tree:

The following table displays the detail record for the tree, which contains the related column, Store_ID, and other columns including Mgr_ID and Employee:

The following table shows the results of the default join when you connect the detail tree and detail record in the Application Source Qualifier:

The US-W-CA-2334-2434 row from the tree appears twice, once for each value in the Store_ID column that falls within the range, 2334 to 2434. The 3234 store ID row from the detail record does not appear in the result set because it is not included in the detail ranges of the tree. The PowerCenter Integration Service replaces the missing node in the US-W-534 row with NULL.