2 Replies Latest reply: Feb 26, 2014 9:38 PM by FPonte RSS

    Is it possible to generate multiple target rows with a single source row?

    9ee1db9c-21da-490c-b281-1695e00acaaf

      Here is the problem:

       

      Each row on the source table has period (number of months) and amount, the amount can be split between the months (I have a formula for it)....

       

      What I want to do is for each source row, insert on target one line per month with its corresponding amount.

       

      Is this (each source row inserting multiple rows on target) possible to be done in ODI using interfaces?

       

      I am using ODI 10 :S

       

      Thanks!