title: ODI || Create Multiple Rows From Single Comma Separated Row
body: <p>I have a comma separated list of values for 2 columns and a unique key for single row. I want to create a single row for each comma separated row with key repeating for each value.</p>
  
  <p>For Example,
  I have </p>
  
  <pre><code>Unique_Id ||  Date                 || Price
  abc       || 2013/01/10,2013/01/11 || 12,13
  </code></pre>
  
  <p>What I want is</p>
  
  <pre><code>abc || 2013/01/10 || 12
  abc || 2013/01/11 || 13
  </code></pre>
  
  <p>The comma separated values can be upto n.</p>
  
  <p>I am using ODI 11g (Oracle Data Integrator).
  How can I do this?</p>