How to eliminate duplicates from flat file..what is the
procedure
- 4 Answers
- 8660 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 |
Hi experts, For informatica developer, in real time, normally how much we use sql and plsql?
What happens if the info. Server doesn't find the session parameter in the parameter file?
What is the advantage of informatica?
How can yoU create or import flat file definition in to the warehouse designer?
i have flat file it contains 'n' number of records, i need to send half of the records to one target table and Remaining half to another target table. can any tell me procedure.
In pmcmd command we need to type -p:password. Will it be visible to others who is having access to this file ?
How we can create indexes after completing the loan process?
Does an informatica transformation support only aggregate expressions?
version controlling in informatica?
What is mapping debugger?
How does a rank transform differ from aggregator transform functions max and min?
What is an active transformation?
Teradata 
