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
without table how to come first record only in oracle?
How are the sources and targets definitions imported in informatica designer?
What is union transformation?
What are the differences between oltp and olap?
How to delete duplicate row using informatica?
can any one give some examples for pre sql and post sql(Except dropping and creating index).
How do you remove duplicate records in informatica? And how many ways are there to do it?
What is a code page?
How can repository reports be accessed without sql or other transformations?
How to partition the Session?
What is the benefit of session partitioning?
What are the different clients of powercenter?
Can we create two repositories on same database instance in oracle?
can we override a native sql query within informatica? Where do we do it? How do we do it?
How can we use mapping variables in informatica? Where do we use them?