Interested to Buy Any Domain ? << Click Here >> for more details...
How to eliminate duplicates from flat file..what is the
procedure
- 4 Answers
- 8089 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 load relational source into file target?
HOW TO JOIN THE 2 FLAT FILES WITHOUT USING JOINER AND LOOKUP?
how i will stop my workflow after 10 errors
Informatica software installation 8.1/7.1.3/7.1 with oracle 10g database (optional Teradata v2R6)
What is difference between Informatica 6.2 Workflow and Informatica Workflow 7.1
How will you update the row without using update statergy?
Source is a flat file and want to load unique and duplicate records separately into two separate targets; right??
What are the differences between joiner transformation and source qualifier transformation?
how to create a sample mapping for dynamic lookup transformation
In which circumstances that informatica server creates Reject files?
What is the difference between view and materialised view?
Is scd logic we have lookup right to compare the values with source and target,instead of lookup can u have any transformation or any way to do this?
Teradata 
