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

Sourcing XLATTABLE Data

You can access XLATTABLE data as a PeopleSoft source and join it to a related PeopleSoft record in a single Application Source Qualifier transformation. The join type in an Application Source Qualifier is an inner equijoin. With an inner equijoin, the PowerCenter Integration Service extracts data from one source table when it finds a matching row in the other source table. It does not extract rows without matching rows. If you want the PowerCenter Integration Service to extract all rows from a PeopleSoft record, regardless of whether the matching row appears in the XLATTABLE table, use the XLATTABLE table as a lookup table.

Complete the following steps to use the XLATTABLE table as a source:

Import the XLATTABLE table as a PeopleSoft source definition.

Add the XLATTABLE source definition to the mapping.

Override the default query in the Application Source Qualifier transformation.

Configure the database connection and run the workflow.

Accessing XLATTABLE Data

Step 1. Import the XLATTABLE Table from PeopleSoft

Step 2. Add the XLATTABLE Source Definition to the Mapping

Step 3. Override the Default Query

Step 4. Configure the Application Connection and Run Workflows

Download Guide

Watch