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

explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?

2164

---

What is workflow? What are the components of the workflow manager?

1146

---

Can we create two repositories on same database instance in oracle?

1098

---

Please let me know how to make Data masking in informatica..

1729

---

How we can create indexes after completing the load process?

1161

---

How to create or import flat file definition in to the warehouse designer?

1071

---

In which transformation you cannot drag ports into it?

1321

---

Briefly explain the aggregator transformation?

1011

---

Explain pmcmd command usage in informatica

1139

---

draw informatica architecture 8.6 ?

3874

---

What is a filter transformation?

1049

---

What is the function of union transformation?

1137

---

As union transformation gives UNION ALL output, how you will get the UNION output?

1109

---

Tell me about MD5 functions in informatica

929

---

Differentiate between source qualifier and filter transformation?

1584

---