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 sessions. Explain how batches are used to combine executions?
Could you explain what is enterprise data warehouse?
difference between repository database and repository service?
What is the maplet?
What is blocking transformation?
What are roles and groups and benefits of using them?
How to extract the informatica rejected data?
Informatica settings are available in which file?
How to generate sequence numbers?
What is option by which we can run all the sessions in a batch simultaneously?
Briefly define reusable transformation?
Explain incremental aggregation in informatica
In development project what is the process to follow for an etl developer from day1
waht type of interface is used for testing the data in informatica
explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?