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
Difference between Target-based loading and constraint-based loading?
what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?
Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?
what is size of u r database?
if we have a delimiters at unwanted places in a flat file how can we over come those.
lookup transformation with screenshots
How do you load more than 1 max sal in each department through informatica or write sql query in oracle?
What are roles and groups and benefits of using them?
How to use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
What is standalone command task?
Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?
What is the need of an ETL tool?
Mention few advantages of router transformation over filter transformation.
I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.
Mention a few design and development best practices for informatica?
