Preface
Configuring PowerExchange for PeopleSoft
Understanding PowerExchange for PeopleSoft
Working with PeopleSoft Sources
Application Source Qualifier for PeopleSoft Sources
Accessing XLATTABLE Data
Creating PeopleSoft Sessions and Workflows
- Configuring a Session for PeopleSoft Sources
- Scheduling a Workflow
Appendix A: Datatype Reference
- PeopleSoft and Transformation Datatypes
Appendix B: PeopleSoft Language Codes
- PeopleSoft Language Codes
Appendix C: Glossary
- PeopleSoft Glossary of Terms

PowerExchange for PeopleSoft User Guide for PowerCenter

10.5
- 10.5.8
- 10.5.7
- 10.5.6
- 10.5.4
- 10.4.0

Back Next

Step 3. Override the Default Query

To extract the data you need from the XLATTABLE table, enter a join override and filter conditions in the Application Source Qualifier transformation. The join override allows the PowerCenter Integration Service to compare the two source columns with codes: the column containing codes in the PeopleSoft record with the XLATTABLE FIELDVALUE column. The filter ensures the PowerCenter Integration Service extracts only data from the XLATTABLE table that relates to the PeopleSoft record.

Sourcing XLATTABLE Data

Entering the XLATTABLE Join Condition

Entering the XLATTABLE Source Filter

Download Guide

Watch

Comments

Communities

Knowledge Base

Success Portal