Table of Contents

Search

  1. Preface
  2. Configuring PowerExchange for PeopleSoft
  3. Understanding PowerExchange for PeopleSoft
  4. Working with PeopleSoft Sources
  5. Application Source Qualifier for PeopleSoft Sources
  6. Accessing XLATTABLE Data
  7. Creating PeopleSoft Sessions and Workflows
  8. Appendix A: Datatype Reference
  9. Appendix B: PeopleSoft Language Codes
  10. Appendix C: Glossary

PowerExchange for PeopleSoft User Guide for PowerCenter

PowerExchange for PeopleSoft User Guide for PowerCenter

Working with PeopleSoft Sources Overview

Working with PeopleSoft Sources Overview

Use the following PeopleSoft sources in a mapping:
  • Records.
    Similar to a relational table. You can import PeopleSoft SQL table and SQL view records.
  • Trees.
    An object describing the hierarchical relationships between values in a single column of the detail record. You can import detail trees, summary trees, and winter trees.
You can either import or create source definitions. You can only import PeopleSoft records. When importing a PeopleSoft source definition, the Designer imports PeopleSoft metadata that is not configurable in the Source Analyzer. Therefore, do not manually create source definitions for PeopleSoft records.
You can either import a PeopleSoft tree or create a tree source definition for a tree, depending on the tree type. You can only import strict-level trees. You can create a tree source definition for either strict-level or loose-level trees.
When you import an effective dated PeopleSoft record, you connect to the PeopleSoft system to access the PeopleSoft metadata tables. The Designer uses metadata in these tables to create the source definition. You cannot configure this metadata manually.

0 COMMENTS

We’d like to hear from you!