Five Stars

mapping for following scenario

 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

1 REPLY
Twelve Stars TRF
Twelve Stars

Re: mapping for following scenario

Hi,

tDenormalize is what you need for such a case.

Capture.PNG


TRF