span8
span4
span8
span4
I'm testing a 亚搏在线workflow that permit to rollback all the changes made in a workbench execution.There is a possibility to rollback some operations from start to end including the truncate operation?
I have a 亚搏在线workflow that read data from a source and write in another one.Writers are set to truncate.If the write process has an error and the workbanch has a failure the truncate process is commited.I'm not able to rollback before the truncate step.Anyone has an idea?
A possibility is to have a staging area and if the workbench is completed without problems a second 亚搏在线workflow start with the real update from staging area to the work area.
I agree fully about using a staging area,I would consider that the best-practice solution.
When data has been fully loaded into the staging area it's usually very simple to copy the data into the production schema using a SQLExecutor and something like
begin delete from prod.my_table;insert into prod.my_table select * from staging.my_table;commit;end;
Not only would that be a single transaction,but it would also be much faster than doing the transfer with FME since no data leaves the database,which means reduced down-time on the production datasets.
SqlExecutor atomic transaction by '"commit".1 Answer
Undefined macro `VALUE_ATTR_ALIAS'3 Answers
Are braces required?4 Answers
© 2019 亚搏在线Safe Software Inc |Legal