This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
- The entire table's data (not the table itself/structure) will be deleted and the data feeding the Output tool will replace it.
- Take the records feeding the Output tool will just be added (like a union) into the table.
- Imagine it executing this SQL statement: Drop Table (TableName); Create Table (your incoming data here). This option would be used over the Delete and Append if you wanted to change the primary keys or needed to add/remove fields
Is there any way to intercept the SQL being sent to the server from the In-DB Output Tool to confirm this?
I tried using the Dynamic output - but that can't intercept from between two in-DB tools because it connects to the back-end of an in-DB tool and then feeds it out to std tools. (reason why I'm asking, is that if the in-DB tool performs TRUNCATE then there is no need to do the Netezza GROOMs on the tables being overwritten to recover space on large or regular overwrites - and which allows us to confirm with the DB admins that we're adhering to their best-practice - though perhaps we could ask them to monitor the server log to confirm for us)