Answer Posted / nanda

In expression transformation take a variable port, lets say
v_emp_id and equate it to emp_id,

take one more variable port for calculation as v_cal
and write a expression in v_cal as

v_cal= iff(emp_id=v_emp_id, emp_name||v_cal, emp_name)-----
----- (1)

take an output port O_emp_name and
O_emp_name = v_cal

write the following as shown in the expression
transformation, i meant the order of ports and their
corresponding values

emp_id
emp_name
v_cal the (1) expression
v_emp_id emp_id
O_emp_name v_cal


send the output ports to aggregator and in aggregator
take a output port O_agg_emp_name

emp_id
emp_name
O_emp_name
O_agg_emp_name = last(O_emp_name)

send the emp_id and the O_agg_emp_name to the target
and thts it

can anyone suggest best free Talend data integration training online

1622

---

How can you define user defied event?

975

---

What is exclusive and normal mode for repository services?

1061

---

What are the advantages of using informatica as an etl tool over teradata?

968

---

Design a mapping to load the cumulative sum of salaries of employees into target table?

1422

---

What are the performance considerations when working with aggregator transformation?

1094

---

What are the components of workflow manager?

1017

---

How union transformation is used?

954

---

Enlist some properties of sessions.

1020

---

How identifying bottlenecks in various components of informatica and resolving them?

1054

---

During the running session, output files are created by informatica server. Enlist few of them.

930

---

What is a joiner transformation and why it is an active one?

997

---

What is the Rank index port in Rank transformation?

1011

---

What are the components of the workflow manager?

1078

---

How to generate sequence numbers?

1028

---