how eliminate the duplicates in flat file with out using sorter ,aggregater

how eliminate the duplicates in flat file with out using
sorter ,aggregater

Question Posted / sbvprasad

4 Answers
11131 Views
Wipro, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

how eliminate the duplicates in flat file with out using sorter ,aggregater..

Answer / kish

Hi Krishna,

i think you r wrong...he is asking abt flat file...
by using LOOKUP we can eliminate duplicates...
You can eliminate duplicates and can capture that duplicates
using
dynamic lookup cache. look up the target table if New lookup
row=0 then it is unchanged (duplicate
record) SEND TO ONE TARGET

Is This Answer Correct ?

17 Yes

0 No

how eliminate the duplicates in flat file with out using sorter ,aggregater..

Answer / srinivas

we can do by using rank transformation also
select rank as 1 top or bottom what ever the ur requirement
and select the group by port for the duplicate column

Is This Answer Correct ?

12 Yes

2 No

how eliminate the duplicates in flat file with out using sorter ,aggregater..

Answer / sanjay

here i m taking the example of employee table

first use the sorter to get the distinct value....

then use the agg trns, create the output port and use the
count function on employee_id to get the total no. of rows
like.. count(employee_id) and group by employee_id.

create filter trns.. write a condition where output>1... map
it with the target...

Is This Answer Correct ?

0 Yes

8 No

how eliminate the duplicates in flat file with out using sorter ,aggregater..

Answer / krishna

The source qualifier Trns has select distinc option from thr we can eliminate duplicates

Is This Answer Correct ?

6 Yes

38 No

Post New Answer