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 native users?

1162

---

What is flashback table ? Advance thanks

1936

---

If informatica has its scheduler why using third party scheduler?

1268

---

What are the performance considerations when working with aggregator transformation?

1152

---

What is the function of look up transformation?

1123

---

What is mapping debugger?

1012

---

Whats the difference between informatica powercenter server, repositoryserver and repository?

1174

---

What is the difference between router and filter?

1269

---

Differentiate between router and filter transformation?

1012

---

Define the various join types of joiner transformation?

988

---

What are the tasks that source qualifier perform?

1106

---

How to extract the informatica rejected data?

1220

---

What is a shortcut and copy in Informatica and how two are different with each other?

1197

---

Differentiate between reusable transformation and mapplet.

1095

---

Reusable transformation and shortcut differences

1840

---