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
In what scenario we use to improve session performance by pushdown optimization?can any one give example?
How to create a non-reusable instance of reusable transformations?
What do you mean incremental aggregation?
Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?
How can you increase the performance in joiner transformation?
How to do unit testing in informatica? How to load data in informatica ?
Define joiner transformation?
What is a mapplet/worklet in informatica?
Explain the features of connected and unconnected lookup.
What is the fact table?
How we can create indexes after completing the load process?
What is meant by lookup transformation?
In informatics server which files are created during the session rums?
tell me 5 session failure in real time how can you solve that in your project?
can anyone suggest best free Talend data integration training online