Figure 4: Single SQL statement for extract and populate

INSERT INTO target
  SELECT col1, col2, col3, col5, col7, col8
    FROM tab1
   WHERE tranId=1234 AND tranDate = ‘2007/04/20’;