How can we delete duplicate rows from flat files ?

Questions by phanimv   answers by phanimv

Showing Answers 1 - 18 of 18 Answers

amarnath

  • Dec 2nd, 2006
 

by using aggregater

  Was this answer useful?  Yes

phani

  • Dec 4th, 2006
 

Sorter Transofrormation do the records in sorting order(for better performence) . iam asking how can we delete duplicate rows

  Was this answer useful?  Yes

s

  • Dec 27th, 2006
 

use a lookup by primary key

  Was this answer useful?  Yes

manisha.sinha

  • Dec 29th, 2006
 

In the mapping read the flat file through a Source Definition and SQ. Apply a Sorter Transformation , in the property tab , select distinct . out put will give a sorter distinct data , hence you get rid of duplicates.

You can also use an Aggegator Transformation and group by the PK. Gives the same result.

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions