ravi

• Oct 23rd, 2007

 

You can put sorter transformation after source qualifier transformation and in sorter tranformation' properties enable distinct property.

Thanks

kumar

vivek1708

 Profile Answers by vivek1708 

• May 11th, 2008

 

In order to beable to delete those entries
I think, you'll have to write sql queries in teh data base table
using rownum/rowid concept.

Or

by using the sorter and distinct option, load the unique rows in a temp table
followed by a truncate on the original table
and moving data back to it from the temp table.

hope it helps.

balaji_r

 Profile Answers by balaji_r 

• Feb 24th, 2009

 

use aggregate on primary keys

avneeshrathor

 Profile Answers by avneeshrathor 

• Nov 3rd, 2009

 

Using sorter (with distinct option checked) will not tell what all records were duplicate. There is even a better way of doing it without using aggregator and all. it just uses expression transformation.