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. Datatype Reference
  9. PeopleSoft Language Codes
  10. Glossary

PowerExchange for PeopleSoft User Guide for PowerCenter

PowerExchange for PeopleSoft User Guide for PowerCenter

Configuring a PeopleSoft Session to Partition Data

Configuring a PeopleSoft Session to Partition Data

If you need to extract a large amount of source data, you can partition the sources to improve session performance. Partitioning sources allows the PowerCenter Integration Service to create multiple connections to sources and process partitions of source data concurrently. You can partition sources if the PowerCenter Integration Service can maintain data consistency when it processes the partitioned data.
By default, the Workflow Manager sets the partition type to pass-through for PeopleSoft trees. In pass-through partitioning, the PowerCenter Integration Service passes all rows at one partition point to the next partition point without redistributing them. You can also specify key range partitioning for PeopleSoft trees. In key range partitioning, the PowerCenter Integration Service passes data through each partition depending on the ranges specified for each port.
You cannot create multiple partitions on an Application Source Qualifier for PeopleSoft when it is connected to or associated with a PeopleSoft tree.

0 COMMENTS

We’d like to hear from you!