Database Reference
In-Depth Information
To add the distinct command in your query, double-click on the Source Qualifier trans-
formation, click on the
Properties
tab, and check the
Select Distinct
option, as shown in
the following screenshot:
This will be possible only if your source is a database table and only if you wish to select
unique records at the source level. If you wish to get unique records in between the map-
ping, you need to use the Sorter transformation, which also provides the ability to remove
duplicates.