CODEWITHSUNDEEP
pentahoetlkettlepentaho-design-studiopentaho-cde
Sushant
Sushant

Reputation: 173

How to ensure transformations with output to more than one output table are carried out as atomic operations in Pentaho Kettle

I am totally new to ETL's in general and working on Pentaho kettle. I have made some transformations which involve writing output to more than one database tables and want to make sure that writing to these multiple tables is carried out as an atomic operation i.e. in a transaction so that in case of any errors the entire thing can be rolled out. Need help on how that can be done.

Upvotes: 1

Views: 291

Answers (1)

Noah
Noah

Reputation: 1857

In Spoon, go to the Transformation properties (Ctrl-T), select the "Miscellaneous" tab and tick the box next to "Make the transformation database transactional"

If you work with the raw XML, it's the <unique_connections>N</unique_connections> option under

<transformation>
  <info>

Upvotes: 1

Related Questions