PowerExchange for PeopleSoft User Guide for PowerCenter

10.5.7
- 10.5.8
- 10.5.6
- 10.5.4
- 10.5
- 10.4.0

Back Next

Configuring an Application Source Qualifier

By default, the Designer creates an Application Source Qualifier when you drag a PeopleSoft source definition into the Mapping Designer. Do not edit the datatypes in the Application Source Qualifier. The datatypes determine how the source database binds data when you import it. The datatypes in the source definition must correspond with the datatypes in the Application Source Qualifier. Otherwise, the mapping is invalid.

To configure an Application Source Qualifier:

In the Mapping Developer, double-click the title bar of an Application Source Qualifier.

Click the Properties tab.

Optionally, enter the following settings:

Option	PeopleSoft Source Definition Types	Description
Filter	Records	Filter conditions the PowerCenter Integration Service applies when extracting source rows. When you enter a filter, the Designer adds the filter to the default query. Use syntax supported by the source database. Enter only the filter condition, do not type WHERE.
Join Override	Records	Join conditions to join data from connected sources. Overrides the default join. When you enter a Join Override, the Designer adds the join to a WHERE clause in the default query. Use syntax supported by the source database. Enter only join conditions. Do not enter WHERE.
Extract Override	Records	Overrides the default query. Specifies the query you want the PowerCenter Integration Service to use to extract data from PeopleSoft records. Enter the entire extract query with syntax supported by the source database. If you enter an Extract Override, the Designer ignores any changes you make to transformation properties. The PowerCenter Integration Service uses the extract override to query sources. It does not perform language code queries. Use for PeopleSoft records only. If you connect the Application Source Qualifier to a PeopleSoft tree, the PowerCenter Integration Service ignores the extract override. It uses the default query.
Number of Sorted Ports	Records	Number of columns from a PeopleSoft record the PowerCenter Integration Service sorts. If you select this option, the Designer adds an ORDER BY to the default query and sorts the specified number of columns, beginning at the top of the Application Source Qualifier. Use for PeopleSoft records only. The Designer ignores PeopleSoft tree ports connected to the Application Source Qualifier.
Tracing Level	Records, Imported Trees, Created Tree Source Definitions	Amount of detail included in the session log when you use a session containing this transformation.
Select Distinct	Records	Selects only unique source rows. If you choose this option, the Designer uses SELECT DISTINCT in the default query.
Extract Current Rows	Records	Extracts the current rows from effective dated records. Uses the date in Extract Date as the current date. When you use this option, the Designer modifies the default query and default join to select only the most recent data as defined by the extract date. When you use this option, the PowerCenter Integration Service extracts only one row for each key. Use for effective dated PeopleSoft records only.
Extract Date	Records	Current date to use with the Extract Current Rows option. To use the current date, leave this attribute empty. Enter the date in the following format: MM/DD/YYYY HH24:MI:SS Use for effective dated PeopleSoft records only.
Effective Date Join Order	Records	Join order between effective dated records. When you use this option, the PowerCenter Integration Service joins a row from the second table with a row from the first table. The effective date of the row from the second table is the maximum date less than or equal to the effective date of the row from the first table. Use for multiple effective dated PeopleSoft records only.