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 we create a node as a gateway node and the same node can be assigned to a grid?

1125

---

What is transformation?

1159

---

What is a router transformation?

1213

---

Explain the different dimensions.

1008

---

can u any challenge your project?

2085

---

What is workflow manager?

1100

---

What is status code in informatica?

1065

---

What is InformaticaPowerCenter?

1179

---

What is the different lookup cache(s)?

1131

---

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

1232

---

What is DR strategy for Informatica project?

1226

---

Do you find any difficulty while working with flat files as source and target?

1149

---

How we can create indexes after completing the load process?

1201

---

My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?

6580

---

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

1172

---