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
- 12461 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
What are ETL Tools?
What is flashback table ? Advance thanks
WHAT IS EDM?WHAT IS THE USE IN INFORMATICA? chandumba2005@gmai.com
What are the types of lookup transformation?
What is status code in informatica?
How we can create indexes after completing the load process?
What does update strategy mean, and what are the different option of it?
What is dimensional table?
Explain what transformation and how many are there in informatica?
What is enterprise data warehousing?
what is the size ur source like(file system or database)? how many record daily come u r banking project?
What is a router transformation?
What are mapplets?
how many types of dimensions are available in informatica?
How is union transformation utilized?
