source target
--------- --------
name no sal name no sal max_sal
r 10 1000 r 10 1000 3000
y 20 3000 y 20 3000 3000
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
Explain dynamic target flat file name generation in informatica
What are the types of schemas we have in data warehouse.
how we can load rejected record's at run time?(not through bad files)
What is the difference between stop and abort in informatica
What is intricate mapping?
Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance
how to load rows into fact table in data warehouse
How identifying bottlenecks in various components of informatica and resolving them?
What is complex mapping?
What are the components of the workflow manager?
What is meant by LDAP users?
what is the size of your data warehousing?
What is a filter transformation?
How does a rank transform differ from aggregator transform functions max and min?
How to join three sources using joiner?