Karthikeya

• May 22nd, 2006

 

keep aggregator between source qualifier and target and choose group by field key, it will eliminate the duplicate records.

Nanda Kumar

• May 22nd, 2006

 

Hi , Before loading to target , use an aggregator transformation and make use of group by function to eleminate the duplicates on columns .Nanda

Sudhakar Reddy

• May 22nd, 2006

 

Use Sorter Transformation. When you configure the Sorter Transformation to treat output rows as distinct, it configures all ports as part of the sort key. It therefore discards duplicate rows compared during the sort operation

nan.kumar

 Profile Answers by nan.kumar 

• May 22nd, 2006

 

Hi, Before loading to target Use an aggregator transformation and use group by clause to eliminate the duplicate in columns.Nanda

afzal pathan

• May 25th, 2006

 

Use sorter transformation ,select distinct option  ,duplicate rows will be eliminated.

srinivasgogineni

• May 27th, 2006

 

if u want to delete the duplicate rows in flat files then we go for rank transformation or oracle external procedure tranfornation

select all group by ports and select one field for rank,its easily dupliuctee now

sai

• Jun 13th, 2006

 

Hi

using Sorter Transformation we can eliminate the Duplicate Rows from Flat file

Thanks

N.Sai

mootati raghavendroa reddy

• Jun 23rd, 2006

 

to eliminate the duplicate in flatfiles, we have distinct property in sorter transformation. If we enable that property, automatically it will remove duplicate rows in flatfiles.