mapping for following scenario

[Anonymous]

 There is a source table containing 2 columns Col1 and Col2 with data as follows:

    Col1       Col2
    ——        ——

     a              l
     b             p
     a             m
     a             n
     b             q
     x          y

    Design a mapping to load a target table with following values from the above mentioned source:

    Col1       Col2

    ——        ——
      a            l, m, n
      b            p, q
      x            y

[TRF]

Hi,

tDenormalize is what you need for such a case.