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.