Answer / 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.

Answer / lokesh y g

using dynamic lookup we can do it......

i have to extract data from a flat file.the flat file has 10 records.i have to extract the 1st and 5th record every time.how is it done.

10 Answers   Emirates, IBM,

---

How to load last 10 records of flat file in to the target?

5 Answers   iNautix,

---

What is confirmed dimension with scenario

1 Answers   HCL,

---

What is Code Page Compatibility?

1 Answers  

---

Can anyone tell me the new features in Informatica 9 Version?

0 Answers   Syntel,

---

---

What is difference between maplet and reusable transformation?

2 Answers  

---

What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?

2 Answers   TCS,

---

How many joins in Informatica

5 Answers   CSC,

---

If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b,the target shd be loaded as 1 a+b+c or 1 a||b||c, what transformations shd be used for this?

3 Answers   CTS, Wipro,

---

What is polling?

1 Answers  

---

Differentiate between mapping parameter and mapping variable?

1 Answers  

---

In dimension and fact table? which one holds big data?

2 Answers  

---