Interested to Buy Any Domain ? << Click Here >> for more details...
How to eliminate duplicates from flat file..what is the
procedure
- 4 Answers
- 8368 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 |
I have a scenario with router transformation. but i dont want to capture records from default group. how can we achieve this.
Can anyone please distinguish what is Inner join and Outer join
without table how to come first record only in oracle?
What is difference macros and prompts?
write a sql query following table some duplicate present 1 1 2 2 3 3 4 5 i want the output unique one column duplicate another column following format like unique duplicate 1 1 2 2 3 3 4 5
what is metadata?
How to go to the older version for a mapping?
How do you handle decimal places while importing a flatfile into informatica?
One flatefile it contains some data but i want to dont want to load first and last record ..how it is? can u tell me complete logic?
can u explain me banking domain projects ? and in banking domain projects how many dimension tables and how many fact tables and how to load source and targets in mapping level plese expain give me one example?
1 Answers Accenture, Cognizant, HCL, IBM, iGate, L&T, TCS, Virtusa,
How can you run a session without using server manager?
A session S_MAP1 is in Repository A. While running the session error message has displayed
Teradata 
