PowerExchange for PeopleSoft User Guide for PowerCenter

10.4.0
- 10.5.8
- 10.5.7
- 10.5.6
- 10.5.4
- 10.5

Back Next

Joining Source Data

If you have multiple PeopleSoft sources in a mapping, you can connect them to a single Application Source Qualifier. This allows the PowerCenter Integration Service to read all connected tables in a single pass. Single pass reads can reduce the total connection time to the source system and improve session performance.

You can connect multiple PeopleSoft sources to an Application Source Qualifier if all of the following conditions are true:

All sources are located in the same database.

All sources have logical relationships.

All sources are imported, not created in the Designer.

When you join sources in one Application Source Qualifier, the Designer creates a join based on the relationships between sources.

If you need to join a created tree source definition with another source, for example a detail record, you must use a Joiner transformation.

The Application Source Qualifier provides two types of joins:

Default join.
The Designer creates a default join based on connected import ports and the implicit relationships between connected or associated sources.

Join override.
You can enter a join override to customize the default join.

Application Source Qualifier for PeopleSoft Sources

Download Guide

Watch

Comments

Communities

Knowledge Base

Success Portal