Specify sorted ports.

When you specify a number for sorted ports, the Designer adds an ORDER BY clause to the default query for PeopleSoft records. This orders source data by the number of ports you enter.

Select only distinct values from the source.

When you choose Select Distinct, the Designer adds a SELECT DISTINCT statement to the default query. This returns only distinct source rows.

Join data from the same PeopleSoft system.

When you join sources, the Designer adds the join conditions to a WHERE clause in the default query. You can join two or more PeopleSoft records with key relationships by connecting them to one Application Source Qualifier. You can also join a detail tree with its detail record for imported tree sources. Use the default join or create a custom join.

Filter data.

When you enter a source filter, the Designer adds the filter conditions to a WHERE clause in the default query. Use a source filter to remove source rows you do not need in the data flow.

Create a custom extract query.

You can create an extract override for PeopleSoft records. An extract override replaces the default query. You can create an extract override that includes defined transformation settings, or you can override all existing transformation settings.

Extract current data.

You can include a WHERE clause in the default query to return only the current rows according to the date you specify.

Filter

Join Override

Extract Override

Number of Sorted Fields

Tracing Level

Select Distinct

Extract Current Rows

Extract Date

Effective Date Join Order