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.

my source is junk data how will u remove that junk data by using unix please any one replay me

3690

---

How would you copy the content of one repository to another repository?

998

---

Explain scd type 3 through mapping.

967

---

What is a sequence generator transformation?

1002

---

How to generate or load values in to the target table based on a column value using informatica etl tool.

1054

---

How can we handle two sessions in informatica?

1021

---

Explain how many types of dimensions are available in informatica?

1075

---

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

1090

---

how to create user defined function (udf) in informatica

1290

---

What are the differences between joiner transformation and source qualifier transformation?

1152

---

What are the new features of informatica 9.x at the developer level?

1030

---

Explain the different dimensions.

947

---

What are batches?

1080

---

What is the function of look up transformation?

1112

---

What is the fact table?

1051

---