if the output of a workflow is to truncate and update a table - is there anyway to ensure all work prior to the update is complete? sort of a checkpoint that all is ready to update?
This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
Generally make sure to execute execute actions SQL during flow use transformer SQL executor and before each action verifying performing a select to ensure integrity by, example, I perform, Truncate, on a table, before using a Writer or a SQL Execute to insert, perform a query to verify that the action has actually been performed.
- 8394 replies
Alternatively you can look into the FeatureWriter transformer. I will ouput a summary feature once all the truncate+update operations have terminated.