Distinct

Distinct operation allows removing duplicate records by multiple (or one) columns.

Parameters:

• Source, Space, and Table specify the input table.
• Target Source, Target Space, and Target Table specify the target table.
• Distinct on columns contains a list of columns by which duplicates are identified and removed.