Interested to Buy Any Domain ? << Click Here >> for more details...
How do we eliminate duplicate records in a flat file without using Sorter and Aggregator?
- 7 Answers
- 21546 Views
- iNautix, I also Faced
- E-Mail Answers
Answer Posted / ankur saini
sol--seq gen---rank ---filter
add a sequence generator ...
ex input is
1 a
1 b
2 a
2 b
after seq generator
1 a 1
1 b 2
2 a 3
2 b 4
then ranl it group by all file ports rank on the seq gen key
input seq rank
1 a 1 1
1 b 2 2
2 a 3 1
2 b 4 2
add filter on rank=1
enjoy!!!!!
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What is a router transformation?
What is dimensional table?
Differentiate between a repository server and a powerhouse?
what is the Default Source Option For Update Strategy Transformation?
what is size of u r database?
What is sq transformation?
What is the difference between writing a joiner query in ANSI style and THETA style?
WHAT IS EDM?WHAT IS THE USE IN INFORMATICA? chandumba2005@gmai.com
What do mean by local and global repository?
What is target designer and target load order?
hi friends .i designed mapping in windows but i want to run mapping in linux.should i install the server components in linux?
Explain how to import oracle sequence into informatica?
What are the informatica performance improvement tips
What is an expression transformation in informatica?
1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?
