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
- 11350 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
Write the unconnected lookup syntax?
What are the new features of informatica 9.x at the developer level?
What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?
how to create user defined function (udf) in informatica
What is the use of source qualifier?
What is data movement mode in Informatica and difference between them?
What is the format of informatica objects in a repository? What are the databases that informatica can connect to windows?
What are the advantages of informatica?
In informatica workflow manager, how many repositories can be created?
What is informatica powercenter repository?
If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me
Explain lookup transformation source types in informatica
Quickly characterize reusable change?
Differences between version 7.x and 8.x.
What is a passive transformation?
