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,

---

What is difference between partioning of relatonal target and partitioning of file targets?

2 Answers  

---

Are there any types of Dynamic Caches in informatica

4 Answers   Accenture,

---

hi all, Can anyone please tell me the relationship between informatica and business objects

1 Answers  

---

what is work of PUSH DOWN option

2 Answers   Wipro,

---

My source is EmpID, Salary- (101, 1000)(102, 2000)(103, 3000). In the Target I want the following EmpID, Salary, Composite_Salary- (101, 1000, 1000)(102, 2000, 3000)(103, 3000, 6000). Please guide on how to build the mapping.

5 Answers   Amdocs,

---

What is mapplet and a reusable transformation?

2 Answers  

---

What is meant by active and passive transformation?

0 Answers  

---

suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do

0 Answers   Patni,

---

suppose if we have dublicate records in a table temp n now i want to pass unique values to t1 n dublicat values to t2 in single mapping?how

4 Answers   CTS,

---

How the facts will be loaded? explain

2 Answers   HCL,

---

What differs when we choose the sorted input for aggregator transformation?

0 Answers  

---