You can translate the question and the replies:

Delete flag option at exporter section Denodo scheduler

Hi , please I want to ask about the delete flag option at exporter section at Denodo scheduler ..as when I enable it , all rows deleted even the exporeted rows ? also I want to ask if there is option to delete the rows (which i extract it ) from source table ?
user
05-05-2020 09:07:51 -0400
code

2 Answers

Hi, The Delete table content option will make sure the content of the destination table is deleted prior to inserting the exported tuples from the source. I followed the below steps to delete the extracted data from the source: * Created 2 scheduler jobs. * First one to extract and export data by enabling the Delete table content option. * Second one to delete data from source using delete statement in extraction section. * On the trigger section of the second job, I added a dependency on the first job. To understand more on dependencies, refer to section [Dependencies Among Jobs](https://community.denodo.com/docs/html/browse/7.0/scheduler/administration/creating_and_scheduling_jobs/configuring_new_jobs/dependencies_among_jobs) of the Scheduler Administration Guide. * Based on the trigger we defined on the Second job, it will trigger the job followed by successful execution of the first job. Hope this helps!
Denodo Team
06-05-2020 05:21:31 -0400
code
Yes it helps . thanks alot
user
06-05-2020 05:45:55 -0400
You must sign in to add an answer. If you do not have an account, you can register here