Interested to Buy Any Domain ? << Click Here >> for more details...
How to eliminate duplicates from flat file..what is the
procedure
- 4 Answers
- 8158 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 |
What are the mapping paramaters and mapping variables?
Can a joiner be used in a mapplet.
Name 4 output files that informatica server creates during session running?
why sequence generator should not directly connected to joiner transformation ?
How can a transformation be made reusable?
What is the use of transformation?
have you developed documents in your project? and what documents we develop in realtime?
what is the size of u r source(like file or table)?
Is it possible to create multiple domains on a single Informatica server?
Hi experts, can anyone tell how much we use plsql in real time
Router T/R is active but some people are saying it is also passive which is exactly right?
1.why we need to use unconnected transformation? 2.where we can static chach,dynamic chach
Teradata 
