View Full Version : roll back if error in processflow execution

12-11-2008, 07:04 AM
hello everyone,
i have a doubt that whenever we execute a process flow containing the transformations, if due to a problem any transformation fails then rest transformations don't execute, but rest of transformations executed already populated starts giving result in reporting. so is there any way in which we can hold the transformations populating the data until all the transformations execute successfully? is there any rollback option for other transformation if there is error in the successive?
please reply me.

12-11-2008, 08:05 AM
there could be several solutions for this problem:
1) write all the transformed data into a staging area.. and at the end, when all transformations executed successfully, load it into the target area
2) define custom error handling for the transformations (e.g all transformations in one job, when this job fails execute custom rollback... like delete all records where insert date = transformation-execution-date)

there is no built-in commit/rollback functionality in PDI