title: Deaggregate into single unit level
body: <p>I have the following table that I need to break apart or deaggregate:</p>
  
  <p><code>Order</code> Table:      </p>
  
  <pre><code>Order Id Item   Qty
  O1       A1      5
  O2       A2      1
  O3       A3      3
  </code></pre>
  
  <p>Please provide SQL which will explode the above data into single unit level records as shown below: </p>
  
  <p>Desired Output:     </p>
  
  <pre><code>Order Id    Item    Qty
  O1          A1       1
  O1          A1       1
  O1          A1       1
  O1          A1       1
  O1          A1       1
  O2          A2       1
  O3          A3       1
  O3          A3       1
  O3          A3       1
  </code></pre>
  
  <p>How could I do this in Teradata?</p>