Interested to Buy Any Domain ? << Click Here >> for more details...
source target
--------- --------
name no sal name no sal max_sal
r 10 1000 r 10 1000 3000
y 20 3000 y 20 3000 3000
- 7 Answers
- 12844 Views
- Cap Gemini, I also Faced
- E-Mail Answers
Answer Posted / abhinav prakash
1.Pass the ports to an expression t/r.
create a dummy port and give the value as '1'
2.Pass only the salary port to an Aggregator t/r.
Create a dummy port with the same data type and column name
and value as expression.
create o/p port:max(salary)
3.Join these 2 t/r using joiner and join on the dummy port.
ensure u have checked the sorted input option.
4Pass the o/p to the target.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?
What is domain in terms of informatica?
How to generate sequence numbers?
What are mapplets? How is it different from a Reusable Transformation?
How to implement security measures using repository manager?
Explain the difference between a data warehouse and a data mart?
Plz can any one say me how to get the informatica certification materials and dumps
How do you load only null records into target?
What is the meaning of up gradation of repository?
What is target designer and target load order?
What are the basic requirements to join two sources in a source qualifier transformation using default join?
how we can load rejected record's at run time?(not through bad files)
What is substr in informatica?
What is workflow manager?
can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project
