Learning Informatica PowerCenter 10.x - Second Edition

Selecting distinct records

You can use Source Qualifier to remove the duplicates from the database tables using the Select Distinct option. By default, Integration Service writes the SELECT * statement, that is, it writes the query with all the columns in the default query. When you select the distinct option, Integration Service adds the Select Distinct statement into the query that it generates. Usually, we use the distinct option on the primary key of the database table. To add the Distinct command in your query, double-click on the Source Qualifier transformation, click on the Properties tab, and check the Select Distinct option as shown in the following screenshot:

It will be possible only in case your source is a Database table and ...