2 Replies Latest reply: Sep 14, 2012 9:47 AM by David Allan-Oracle RSS

    Transform one row to be two row in OWB 11g

      Dear Gurus,

      I have source table A which consist fields:Start_date and End_date.
      I want to transform that source table A into destination table B.
      But, in table B just have one date for one row.

      Source Table A:
      row_id start_date end_date
      1 1-jan-2012 3-jan-2012

      transform to :

      Dest Table B:
      row_id date
      1 1-jan-2012
      2 2-jan-2012
      3 3-jan-2012

      what transformation operators should i use?and how to use it?
      I am new on this

      Thank so much before