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
- 21957 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
Define pmcmd command?
Explain the different kinds of facts.
What is the benefit of session partitioning?
What are the different types of repositories created using informatica?
What is union transformation in informatica?
Performance tuning( what you did in performance tuning)
Differentiate between Load Manager and DTM?
What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?
Informatica Server and Client are in different machines. You run a session from the server manager by specifying the source and target databases. It displays an error. You are confident that everything is correct. Then why it is displaying the error?
What is session task and command task?
How to generate or load values in to the target table based on a column value using informatica etl tool.
What is the cumulative sum and moving sum?
What are the components of Informatica? And what is the purpose of each?
Explain what are the different types of transformation available in informatica.
Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?
