How do you avoid duplicate records with out using source qualifier,expression,

How do you avoid duplicate records with out using source
qualifier,expression,aggrigator,sorter and lookup
transformations ?

Question Posted / manojkumar.challagundla

Answers were Sorted based on User's Feedback

How do you avoid duplicate records with out using source qualifier,expression,aggrigator,sorter an..

Answer / triveni

rank transformation
ex: empno,ename
1,ramu
1,ramu
2,rani
2 ,rani

empno(group by),ename(returnport) top1 or bottom1

target: 1 ramu
2 rani

Is This Answer Correct ?

14 Yes

0 No

How do you avoid duplicate records with out using source qualifier,expression,aggrigator,sorter an..

u can use unix command in pre session as sort -u file1
>newfile

Is This Answer Correct ?

8 Yes

3 No

How do you avoid duplicate records with out using source qualifier,expression,aggrigator,sorter an..

Answer / manoj kumar

Good logic.

Thank you

Is This Answer Correct ?

1 Yes

0 No

How do you avoid duplicate records with out using source qualifier,expression,aggrigator,sorter an..

Answer / manojkumar

Thank you prasad.

Is This Answer Correct ?

0 Yes

1 No