If you want the PowerCenter Integration Service to select only unique values from a PeopleSoft Record, use the Select Distinct option.

For example, you enable the select distinct in an Application Source Qualifier. The Designer adds SELECT DISTINCT to the default query, as follows:

You might use Select Distinct to extract unique customer IDs from a table listing total sales. You can filter out unnecessary data early in the data flow, which improves session performance.

By default, the PowerCenter Integration Service uses a SELECT statement to select all data.

To use Select Distinct: