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 are Dimensional table?

1121

---

Explain what are the different types of transformation available in informatica.

1248

---

What is transformation?

1159

---

Target increases every day even though no new record was inserted

1625

---

Explain informatica architecture - version 8 / 9

1153

---

What is event and what are the tasks related to it?

1203

---

what is the end to end process meaning in my project(my project is development)and functionality plz tell me

2072

---

Can you use flat files in Mapplets.

2715

---

Enlist the differences between database and data warehouse.

1166

---

Is stop and abort are same in informatica?

1048

---

State the limitations where we cannot use joiner in the mapping pipeline?

1107

---

What is confirmed fact in dataware housing?

7107

---

Explain the difference between mapping parameter and mapping variable?

1083

---

What is a repository manager?

1148

---

What are the issues you have faced in your project? How did you overcome those issues?

2413

---