Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / ankit kansal
Three ways to achieve the result..
1) Sorter Transformation (Distinct Oprtion)
2) Aggregator Transaformation (Group by ALL PORTS)
3) Rank Transformation (Group by ALL) and RNK=1
http://deepinopensource.blogspot.in/
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
Explain the different lookup methods used in informatica?
Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?
What is the sequence generator transformation in informatica?
What is the difference between STOP and ABORT options in Workflow Monitor?
Explain informatica architecture - version 8 / 9
How to create the source and target database connections in server manager?
Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.
Can u generate reports in Informatica?
What is the session task and command task?
What is meant by incremental aggregation?
How do you load unique records into one target table and duplicate records into a different target table?
can we override a native sql query within informatica? How do we do it?
How to extract sap data using informatica?
How are indexes created after completing the load process?
Can anyone tell me the new features in Informatica 9 Version?
