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

Accessing XLATTABLE Data Overview

PeopleSoft systems use the XLATTABLE table to define codes used in PeopleSoft records. Use PowerExchange for PeopleSoft to access XLATTABLE data to define those codes. For example, a PeopleSoft record might have a row with “A” in the STATUS column. By accessing the XLATTABLE table, you can determine that A stands for “Available.”

In a mapping, you can access the XLATTABLE table in two ways:

As a PeopleSoft source.
You can import the XLATTABLE table as a PeopleSoft source definition and then join it with a PeopleSoft record in an Application Source Qualifier.

When you join source definitions in the Application Source Qualifier, the PowerCenter Integration Service performs an inner equijoin. Use the XLATTABLE table as a source when all source rows in the PeopleSoft record have corresponding records in the XLATTABLE table.

As a database lookup table.
You can also import the XLATTABLE table from the underlying database of the PeopleSoft system. As a relational table, use the XLATTABLE table in a Lookup transformation. You can create Lookup transformations based on PeopleSoft sources.

As a Lookup transformation, you can look up corresponding data in the XLATTABLE table. Use this option to look up more than one column or to perform more complicated queries against the XLATTABLE table, such as choosing the first or last results of a multiple match or replacing null values.

Rename Saved Search

Table of Contents

PowerExchange for PeopleSoft User Guide for PowerCenter

PowerExchange for PeopleSoft User Guide for PowerCenter

Accessing XLATTABLE Data Overview

Accessing XLATTABLE Data Overview