how eliminate the duplicates in flat file with out using
sorter ,aggregater
Answer Posted / srinivas
we can do by using rank transformation also
select rank as 1 top or bottom what ever the ur requirement
and select the group by port for the duplicate column
Is This Answer Correct ? | 12 Yes | 2 No |
Post New Answer View All Answers
Differentiate between router and filter transformation?
In informatica workflow manager, how many repositories can be created?
what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?
What are the popular informatica products?
According to his methodology what all you need before you build a datawarehouse
How would you join a node to the already existing domain?
How do you change a non-reusable transformation to reusable transformation?
How to call shell scripts from informatica?
explain abt ur project architecture?
I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.
What is the difference between Active and Passive transformation?
Explain the scenario which compels informatica server to reject files?
What is a joiner transformation?
How to update a particular record in target with out running whole workflow?
What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?