Answer / rajesh.a

We need to use sorter,Expression and aggregator transformations to do this

1.Sort by ID
2.Take 2 variable ports one for id and one for name and store the values of id and keep on comparing with current id i.e variable is having previous id.
so,if previous id=current id then (variable name)||name otherwise only name.assign the variable name to output port
3.Use aggregator and use last or max(len(name)) to get the result

Answer / saritha

you can use normalizer or expersion transformation.

Answer / somnath pain

In source qualifier use this query
select name from table_name group by id
now apply an aggregator transformation to concate the name
according to the group id.

while for 100 records in source table loaded sucessfully in trgt table . assume ,session will take 10min or 5 min to successfully succeeded. then 100 million records r there in source how much time will take by session to succeeded. there no fail ok.trgt table will load 100 million records with out any errors . don't tell perfect time . assume your self how much time to succeeded?

1 Answers   IBM,

---

What is domain in terms of informatica?

0 Answers  

---

COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1

0 Answers  

---

which one is better performance wise joiner or look up

0 Answers   Informatica,

---

can we load the data with out a primary key of a table? what is target plan?

6 Answers   IBM,

---

---

Have you worked with/created Parameter file

0 Answers  

---

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

9 Answers   Target,

---

can you use flat file for lookup table?why?

2 Answers   HCL,

---

IN SCD TYPE 1 WHAT IS THE ALTERNATIVE TO THAT LOOKUP TRANSFORMATION ?

4 Answers   HP,

---

suppose we have 1 to 10 records.In router transformation we had given two condition A>= 5 A<=5 then what will be the output?

2 Answers   emc2,

---

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

0 Answers  

---

what is shortcut in informatica? difference between shortcut,reusable object?

2 Answers   Virtusa,

---