How do I automate the cleanup of the residual tform tables created by Diyotta?
Unless you are debugging an issue, it is recommended that, in your data flows and job flows to have the “TFORM Cleanup option” to “YES” (this is the default). This ensures the tables, stage files created by Diyotta are cleaned up on successful execution of the flows. In case where there are many tables, stage files that remain in the database and server, use the CLI command “dicmd cleanup” to perform cleanup of these objects.
If you have scheduler license, schedule this as a command task and run it at desired interval. An example command is provided below.
dicmd cleanup -c tform -p DEV_PROJECT -n 7
The command help can be seen by typing “dicmd” from the controller/agent nodes.