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 left outer join?

3 Answers   L&T,

---

Q. Informatica workflow, it is running beyond two hours for last couple of runs, normally it completed less then 30 min., hardly 40 min, last couple of run crossing 2 hours and more in that workflow only one session. now it is aasign to you that how to idenitfy the performance issue of the sesion of production.

0 Answers  

---

What you know about transaction control transformation?

0 Answers  

---

how to create a sample mapping for dynamic lookup transformation

2 Answers  

---

Enlist some properties of sessions.

0 Answers  

---

Discuss the advantages & Disadvantages of star & snowflake schema?

5 Answers  

---

h0w many versions have been developed of onformatica so far?

1 Answers   TCS, TetraSoft,

---

in unconnected lookup , what are the other transformations , that can be used in place of that expression transformation ?

9 Answers   Target,

---

Explain pushdown optimization and types in informatica

0 Answers   Informatica,

---

Aggregator transformation is having fields say a,b,c,d,e group by is enabled on a,b,c with sorted input,How the aggregator transformation process the i/p data?or in which way i/p comes to agg transformation

1 Answers   TCS,

---

what is the difference between repository & Intergration service

1 Answers  

---