title: Loading data of one table into another residing on different databases - Netezza
body: <p>I have a big file which I have loaded in a table in a netezza database using an ETL tool, lets call this database <code>Staging_DB</code>. Now, post some verifications, the content of this table needs to be inserted into similar structured table residing in another <strong>netezza DB</strong>, lets call this one <code>PROD_DB</code>. What is the fastest way to transfer data from <code>staging_DB</code> to <code>PROD_DB</code>? </p>
  
  <ol>
  <li>Should I be using the ETL tool to load the data into <code>PROD_DB</code>? Or,</li>
  <li>Should the transfer be done using external tables concept?</li>
  </ol>