Skip to main content

Use Transactions

Enable to wrap Data Vault ELT load processes in transaction statements.

When enabled, the generated load for Satellite, Link Satellite, Reference and Reference Satellite objects on SQL Server-family targets (SQL Server, Azure SQL Database, Azure Synapse Analytics, Azure SQL Managed Instance, Fabric Data Warehouse and Fabric SQL Database) is wrapped in an explicit transaction, so a failed multi-statement load leaves no partial changes behind.

When to Change This Setting​

Keep the default N when loads are insert-only single statements or when the orchestration layer already provides recovery (see Enable Rollback for SSIS). Enable it when multi-statement Satellite loads (such as end-dated Satellites that update and insert) must be atomic on the target database.

SettingInteraction
End Date SatelliteEnd-dated loads run multiple statements and benefit most from transactional wrapping
Enable RollbackThe SSIS orchestration alternative that removes committed rows from a failed run

Notes​

  • This setting is part of the Data Vault settings category.
  • The default value for this setting is N.