Business and Source-System Unit of Work (they’re not always the same)

Patrick Cuba
21 min readFeb 7, 2023

How a software system depicts the unit of work, relationship or participating business entities in a transaction may be different to how the organisation’s own business rules see these business interactions. No one purchases commercial off-the-shelf (COTS) software that doesn’t automate parts or all their business processes, but you may find that how the software vendor depicts those rules and processes do not exactly fit how you would like to depict or report on them. There may be a myriad of reasons for this such as inadequate testing of the source platform before purchase, lack of support for changes or simply that the budget dictates you implement a less than optimal software package to automate your business processes! This is the reality!

And so, if the source cannot match your business processes and rules exactly and are not able to mould their processes to mirror yours, you may need to solve these business process gaps for yourself. Most of the time, this occurs because that vendor needs to look after their own bottom line and thus have a more generic view of that process or rule to cater for a wider range of their own customers.

Today’s topic is focused on how to depict source-aligned units of work with the business’ unit of work (UoW), they may differ, and by example we’ll discuss why and the rules behind building a raw vault link and a business vault link.

As a reminder, the data vault table types…

For a definition of the terms discussed in this article, please visit:

  • How part of this solution was solved using Apache Spark, “Apache Spark GraphX and the Seven Bridges of Königsberg”, bit.ly/3ezZ6Wh
  • Defining Business Vault, “Data Vault Mysteries… Business Vault”, bit.ly/3rfV7V3
  • The use of Zero Keys, “Data Vault Mysteries… Zero Keys & Ghost Records…”, bit.ly/3vjTXdg
  • What is a Bridge Table, “The Lost Art of Building Bridges”, bit.ly/3MFnXZr

The Business Case

--

--

Patrick Cuba

A Data Vault 2.0 Expert, Snowflake Solution Architect