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.

Explain about HLD and LLD ?

16 Answers   Accenture,

---

in which situations do u go for starflake schema ?

6 Answers   TCS,

---

i have source flat file like 1 a,1 b,1 c,2 a,2 b,2 c i want output as 1 a,b,c and 2 a,b,c ... how can achieve this

5 Answers   TCS,

---

What are the mapping parameters and mapping variables?

0 Answers   Informatica,

---

How to convert flat file into xml file? How to tune joiner?

2 Answers   Accenture,

---

How many numbers of sessions can one group in batches?

0 Answers  

---

Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?

0 Answers  

---

Can we make worklet inside worklet?

1 Answers  

---

Explain where to store informatica rejected data? How to extract the informatica rejected data?

0 Answers  

---

What happens when a session fails and you click on recover?

0 Answers  

---

How to do Half of the table ex: if 1000 records are there means 500 in one table and 500 in second table like this if N number of tables means how to do Half of the table ??????????

2 Answers   TCS,

---

1.why we need to use unconnected transformation? 2.where we can static chach,dynamic chach

4 Answers   Virtusa,

---