PowerExchange for PeopleSoft User Guide for PowerCenter

10.5.7
- 10.5.8
- 10.5.6
- 10.5.4
- 10.5
- 10.4.0

Back Next

Understanding the Default Join

When you connect multiple PeopleSoft source definitions to one Application Source Qualifier, the Designer joins them based on logical relationships between connected and associated sources.

The following table describes how the Designer can create a default join for PeopleSoft source definitions:

Source Type	Join With	Default Join Condition
PeopleSoft record	PeopleSoft record	Joins if records are related. Records are related when both of the following are true: Records contain source columns with matching names. At least one of the matching-name columns is a PeopleSoft key. Records are also related if you define a primary-foreign key relationship in the Source Analyzer. If records are not related, you can join them with a join override.
Imported PeopleSoft detail tree	Detail record	None. You can always join an imported detail tree with the detail record.
Imported PeopleSoft detail tree	Non-detail record	Joins if all of the following are true: The record is related to the detail record for the imported tree. The detail record is connected to or associated with the Application Source Qualifier.