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 is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?
3.how will u get information about bugs how will u rectify the bugs in realtime whch tool we are using to rectify the bugs
What is meant by target load plan?
Name the different lookup cache(s)?
What happens when a session fails and you click on recover?
What is expression transformation?
Briefly explain your complete project(sales) flow, (ie. from source received from client, transformations, then despatch to end user) what are all the process. Kindly give step by step process.
What are the tuning techniques you applied during your last project
if we have a delimiters at unwanted places in a flat file how can we over come those.
How to call shell scripts from informatica?
tell me about your project functionality
What is the session task and command task?
Difference between Target-based loading and constraint-based loading?
Can we create multiple integration service on single repository?
How to load the data from people soft hrm to people soft erm using informatica?