title: How to replicate the values
body: <p>I want to write a query to duplicate each row based on the value in the repeat column. The input table data looks like as below</p>
  
  <pre><code>Products, Repeat
  ----------------
  A,         3
  B,         5
  C,         2
  </code></pre>
  
  <p>Now in the output data, the product A should be repeated 3 times, B should be repeated 5 times and C should be repeated 2 times. The output will look like as below</p>
  
  <pre><code>Products, Repeat
  ----------------
  A,        3
  A,        3
  A,        3
  B,        5
  B,        5
  B,        5
  B,        5
  B,        5
  C,        2
  C,        2
  </code></pre>
  
  <p>Can any body suggest me how to do it in Teradata?</p>