Happy 8th birthday to the Maveryx Community! Take a walk down memory lane in our birthday blog, and don't miss out on the awesome birthday present that all Maveryx Community members get to take advantage of!
Our main navigation will be under construction for the next hour. "Launch Pad" will be moving to "Learn", and the "Introduce Yourself" forum will be moving to a thread in the "General" discussion.
- 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)