I am creating a Dynamic Data Uploading Workspace which will read all .mdb files present inside a folder & upload Data in the corresponding tables in Orace Spatial DB. The problem is the DB user which I have, to perform this Upload operation does'nt have Truncate rights on tables since its not the Table Owner & for policy reasons it cannot be given these rights although it has Insert,Update,Delete rights. How do I Delete records from Tables before inserting new ones? Apart from creating 2 seperate workbenches, First for deleting the records using SQLExecuter & second for inserting using Dynamic writer & connecting the 2 using Batch Processing.
Question
Delete existing records instead of Truncate in Oracle Spatial Writer before Loading new data
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.
+22- Influencer
In the Writer Properties there is a text box called "SQL Statement before reading" (or something like that).
There you can add you DELETE statement.
+18- Supporter
Hi @ashishtwr,
You can use the SQL to Run Before Write, or start your workspace with an SQLExecutor following in with a FeatureReader to read the mdb files.
Hope this helps,
Itay
+26- Contributor
Another option:
Read the MDB files.
Use a Sampler to filter out the first read feature and connect the SQLExecutor to execute the Delete statement(s).
Pass both the output ports of the Sampler to the Dynamic Writer.
In case the SQLExecutor is slow, a FeatureHolder might be needed at the "Not Sampled" port of the Sampler.