my source is like this id,name sal 10 abc 1000,10 pqr 2000, 10 xyz 3000 ,10 jkl 4000 and my requirement is like this 10 abc,pqr,xyz,jkl 2000 .... i have try for this by using expression transformatin its ok of the concatenation of second column but the thing is that on third column if u group by using agg t/r the last value will com i.e 4000 but i asked by a interviewer that i dont want the first or last column i want the middle column i.e 2000 .plz reply for the same

2 Answers   KPIT,

---

Which transformation can be created only as reusable transformation but not as non-reusable transformation?

1 Answers   Informatica,

---

How will you update the first four rows and insert next four rows in a mapping?

5 Answers   CTS,

---

how to improve performence by using sorted input in aggrigator t/r.

2 Answers  

---

How can informatica be used for an organization?

0 Answers  

---

hi all, i have 1 flat file having 10 rows. like:- id name amt 100 a 100 200 b 200 100 n 300 400 p 3000 100 a 100 600 x 6000 Now i want to load half of this data into one flat file and remaining in other flat file.like :- flat file 1 id name amt 100 a 100 200 b 200 100 n 300 ---------------------- ---------------------- flat file 2 id name amt 400 p 3000 100 a 100 600 x 6000 Plz reply me ASAP.

10 Answers  

---

What are roles and groups and benefits of using them?

0 Answers  

---

What are some examples of informatica etl programs?

0 Answers  

---

What do you mean by DTM and Load manager and what is difference between load manager and load balancer?

0 Answers  

---

What is meant by LDAP users?

0 Answers  

---

Are there any types of Dynamic Caches in informatica

4 Answers   Accenture,

---

What is the use of target designer?

0 Answers  

---