Question

how to minimize the time the destination table is cleared and updating


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?


2 replies

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.

Userlevel 4

Alternatively you can look into the FeatureWriter transformer. I will ouput a summary feature once all the truncate+update operations have terminated.

Reply