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
How we can create indexes after completing the load process?
What is a stored procedure transformation?
How can we handle two sessions in informatica?
What is the surrogate key?
What is a repository? And how to add it in an informatica client?
Mention some types of transformation?
What are the new features of informatica 9.x developer?
What does command task mean?
Why do you use Mapping Parameter and mapping variable?
What is DR strategy for Informatica project?
Explain the use of aggregator cache file?
Why is sorter an active transformation?
What is source qualifier transformation in informatica?
What are the informatica performance improvement tips
Does an informatica transformation support only aggregate expressions?
