Interested to Buy Any Domain ? << Click Here >> for more details...
How to eliminate duplicates from flat file..what is the
procedure
- 4 Answers
- 8290 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / sunil
To eliminate duplicates from flat file use sorter in that
select distict option...it will work
| Is This Answer Correct ? | 26 Yes | 0 No |
Answer / ram
one more answer is ....
use an aggeregator transformation and select all ports
as 'group by'...then u will get distinct records...
| Is This Answer Correct ? | 6 Yes | 1 No |
Answer / paulo coelho
In an Unix environment, do:
page YourFile | sort | uniq -c
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / muddam
Select all ports as group by then Create one o/p o_count in
aggregater(o_count>1). Before this you wolud have taken one
sorter trans for sorted data.
It will work out.
| Is This Answer Correct ? | 0 Yes | 0 No |
How to get EVEN & ODD numbers separately?
WHAT IS THE DIFFERENCE BETWEEN .NET AND INFORMATICA?
What are the joiner caches?
 Informatica Checkpoints
what is confirmed fact?
If u r giving different parameter file names in workflow and session for a single mapping parameter, then which one will be executed? The one u given in workflow or the one u given in the session?
What are the rank caches?
Where do we use mapping variables in informatica?
How to update or delete the rows in a target, which do not have key fields?
What is olap (on-line analytical processing?
How do you migrate data from one environment to another?
how we can update a target table without update strategy and update override?
Teradata 
