What are the extract load methods?

Drop, create, load. Truncate, load and Append? Explained...

Load Methods

The load methods is in relation to the way the data is loaded into the destination table.

  • Drop, create, load
    This will delete the destination table, recreate the table, then load in the new data.
  • Truncate, load
    This will remove any old data from the table, then add in the new data, the column names and table schema will persist.
  • Append
    This will add any new data to the bottom of the destination table, any old data will not be deleted. If incremental is supported on the report and the load method is set to append only data where the value of the incremental key is greater than the maximum already within the destination table will appended.