title: teradata sql to insert from a volatile table to a permanent table
body: <p>I have a requirement that I need to store a list of parameters. The parameters will be input as a csv file. They will be inserted into a table if not already existing. I have got a suggestion that I can import this data into a volatile table and use a sql query  like:</p>
  
  <pre><code>insert into table permvariables 
  select * from tempvariables
  minus 
  select * from permvariables;
  </code></pre>
  
  <p>Where tempvariables is my volatile table and permvariables is my permanent table. Will this solution work? Is there a better way to do it?</p>