PowerExchange for PeopleSoft User Guide for PowerCenter

10.4.0
- 10.5.8
- 10.5.7
- 10.5.6
- 10.5.4
- 10.5

Back Next

Sorting Ports

You can sort source data from PeopleSoft records using the Number of Sorted Ports option in the Application Source Qualifier. When you specify the Number of Sorted Ports, the Designer adds an ORDER BY clause to the default query and then includes the configured number of PeopleSoft record ports in the ORDER BY clause. The Designer adds ports to the ORDER BY clause starting with the ports appearing at the top of the Application Source Qualifier.

For example, you set the number of sorted ports to 2 in an Application Source Qualifier. The Designer adds an ORDER BY for the default query that includes the first two ports in the transformation, as follows:

SELECT PS_PROJ_VARY_BA_VW.SETID, PS_PROJ_VARY_BA_VW.BUSINESS_UNIT, PS_PROJ_VARY_BA_VW.PROJECT_ID FROM PS_PROJ_VARY_BA_VW 
ORDER BY PS_PROJ_VARY_BA_VW.SETID, PS_PROJ_VARY_BA_VW.BUSINESS_UNIT

You might use sorted ports to improve performance in Aggregator transformations or to ensure the PowerCenter Integration Service reads columns in a specified order.

The Number of Sorted Ports option applies to ports in a PeopleSoft record. When the Application Source Qualifier is connected only to a PeopleSoft tree, it ignores the Number of Sorted Ports option. When the Application Source Qualifier is connected to a tree and records, it sorts only ports connected to records, ignoring ports connected to a tree.

You can also use a Sorter transformation to sort ports from a PeopleSoft source.

To enter a number of sorted ports:

In the Mapping Developer, edit an Application Source Qualifier transformation, and select the Properties tab.

Enter the number of ports you want the PowerCenter Integration Service to sort by.

Click the Ports tab.

Use the Up/Down arrows to move the ports you want the PowerCenter Integration Service to sort to the top of the list of ports.

The Designer adds the configured number of ports to an ORDER BY clause in the default query, starting with the first listed port. The Designer adds only ports from PeopleSoft record sources.

Rename Saved Search

Table of Contents

PowerExchange for PeopleSoft User Guide for PowerCenter

PowerExchange for PeopleSoft User Guide for PowerCenter

Sorting Ports

Sorting Ports