Answer Posted / abhinav

step1:Pass on the source(name,sal) to an expression
transformation.
create a dummy port and give the value as 1.

In the expression transformation, the ports will be

Name
sal
O_dummy=1

Step2:Pass only the salary port from source to aggregator
transformation.
create a dummy port with the same data type as in expression
and give the value as 1
create an output port with Max(Salary)

In the aggregator transformation, the ports will be
sal
O_dummy
O_sum_salary=max(salary)

Step3:Send the output from the 2 transformation to a joiner
transformation.
Ensure you have checked the sorted input option.
Join both the transformation on the Dummy port.

Step4:Send the output to the target.

What is informatica etl tool?

987

---

To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?

1093

---

What is the sql query overwrite in source qualifier in informatica

1069

---

explain abt ur project architecture?

2170

---

What is the function of look up transformation?

1109

---

What is option by which we can run all the sessions in a batch simultaneously?

1126

---

What is rank transform?

981

---

Explain sessions?

1035

---

What's the layout of parameter file (what does a parameter file contain?)?

2370

---

What are the different components of powercenter?

1032

---

Suppose we do not group by on any ports of the aggregator what will be the output?

1031

---

What is resilience time?

1109

---

What are the types of schemas we have in data warehouse.

946

---

What are the components of Informatica? And what is the purpose of each?

1031

---

Make a note of the quantity vaults made in informatica?

971

---