Interested to Buy Any Domain ? << Click Here >> for more details...
How to eliminate duplicates from flat file..what is the
procedure
- 4 Answers
- 8526 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 |
Explain the aggregator transformation?
Dovelopment work (mapings,workflows)and unit testing also done in informatica ,then wt we do ? pls give me detail?
What are the issues that you have faced while moving your project from the Test Environment to the Production Environment?
source is a flat file empname, empno, sal ram, 101, 1,000 sam, 102, 2,000 ques: my target needs the data to be loaded as sal -1000 and 2000 excluding commas target empname, empno, sal ram, 101, 1000 sam, 102, 2000 how to implement this?
what is song in infrmatica...?
in source one table is there. id value --- ------ 1 a 2 b 3 c 1 d 2 e 1 f in target i want id value ---- ------ 1 a,d,f 2 b,e 3 f How to implement it in informatica without using normalizer transformation?
what is work of PUSH DOWN option
How to do unit testing in informatica? How to load data in informatica ?
Is it possible to use a client with different version than that of its Informatica server?
How do you promote a non-reusable transformation to reusable transformation?
Repository user profiles
how much memory (size) occupied by a session at runtime
Teradata 
