Answer Posted / purushotham perumalla

Create variable ports in Expression transformation to
concat name if the number is same as follows

Assume the input field names are number and name

define the variable ports in expression transformation in
the following order

v_flag = iif(number = v_number,0,1)
v_name = iif(v_flag = 1,name,v_name ||' '||name)
v_number = number
O_name = v_name

The output of o_name will be as follows

number o_name
----------------
101 raja
101 raja sekar
101 raja sekar reddy


Add an aggregator transformation after expression and group
by number. output number and o_name from aggr to target.
As aggr outputs last row in each group by deault it will
send 101 raja sekar reddy to the output.

What do mean by local and global repository?

1226

---

How can a transformation be made reusable?

1167

---

What is meant by lookup transformation? Explain the types of lookup transformation?

950

---

What do you mean by filter transformation?

950

---

What is a connected transformation?

1118

---

What are the prerequisite tasks to achieve the session partition?

1252

---

Explain the types of transformations?

1068

---

tell me 5 session failure in real time how can you solve that in your project?

2303

---

What is meant by incremental aggregation?

1106

---

where to store informatica rejected data?

1093

---

What are the restrictions of union transformation?

1041

---

How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.

1776

---

How does a sorter cache works?

1069

---

What does “tail –f” command do and what is its use as an Informatica admin.

1107

---

How you prepared reports for OLAP?

1597

---