Hi,

If im not mistaken ur qn is
Src
1 A
1 B
1 C
2 G
2 H
2 I
3 L
3 M

I want to get in target like this...
1 A*B*C
2 G*H*I
3 L*M

U can designate the column names as ID and NAME.
Use an expression transformation.Declare two variables for ID and NAME.
ie NAME_V PORT use the expression
IIF(ID_V=ID,NAME_V||'*'||NAME,NAME)
ID_V PORT
IIF(ID_V!=ID,ID,ID_V)

Next pass these ports to an aggregator transformation and do GROUP BY ID.
Then pass to target..

Try this ..It will work perfect...

Regards
Tanya