The DB Transaction Start and DB Transaction End node allow you to model a database transaction e.g. a unit of work that is either completely processed or not at all. So, if all nodes between the DB Transaction Start and DB Transaction End node execute successfully all changes will be persisted in the database. However, if any of the nodes between the two transaction nodes fails none of the changes will be persisted in the database. Notice that most databases do an implicit commit when executing a DDL statement such as create or drop table even within a transaction.
This is a companion discussion topic for the original entry at https://kni.me/w/kWP1OhaY4DXK444n