I'm trying to find more information about the Output Data tool, specifically the Output Options
I need to know specifically how the "Delete Data & Append" option works in regards to big tables (ie 1+ million records).
a) delete the records in the table, then add the new records, OR
b) truncate the records in the table, then add the new records, OR
c) it depends on the database (in which case I'm using Netezza at the moment)
I can't find anything this specific in the help files and the processing time does have an impact at this level and I want to avoid writing the Pre Create SQL Statement if I can.