How do we eliminate duplicate records in a flat file without using Sorter and Aggregator?
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
Hi, I want to do Informatica Designer certification. Can anyone help me by providing the details on this. Thanks in advance. Regards, Arnab
Can some one explain me about Telecommunications(wireless) project in Informatica? Thanks in advance
Different circumstance which drives informatica server to expel records?
tell me 5 session failure in real time how can you solve that in your project?
WHAT IS EDM?WHAT IS THE USE IN INFORMATICA? chandumba2005@gmai.com
Explain the informatica workflow?
Under which circumstances, informatica server creates reject files?
Please let me know how to make Data masking in informatica..
What does role playing dimension mean?
What does reusable transformation mean?
What are the designer tools for creating transformations?
Differentiate between sessions and batches?
What are the different options available for update strategy?
What is InformaticaPowerCenter?
explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?