+5Hi,
I have a workspace that truncates an SDE geometry table and refills it. The workspace runs daily and sometimes there are no records to write. In that case the writer only has to truncate the table. I don't see an option truncate first or anything like that in a sde writer.
How can I truncate a table while the writer is empty?
+34For this sort of scenario, I'd truncate the tables using an sqlexecutor upstream of the writers to ensure all tables are truncated.
In my case I'd like to truncate the table (FGDB feature class) that is in the Reader, after the table has been read. Is that possible?
+48An SQLExecutor downstream of the Reader should do the trick.
Note that one SQL query is issued for each feature that enters the transformer. So do make sure only one feature enters the SQLExecutor!
Maybe use a Sampler (sample the last feature!), or the combination of a Creator and a FeatureReader.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
