Multi-active Satellites

AutomateDV (formerly known as dbtvault)
, ,
1

Has anyone here implemented multi-active satellites using Automate DV package of DBT?

I have a scenario of creating Data Vault on an XML file data. This file is having multiple nested elements for each unique identifier.
I have referred this blog and many other:

As mentioned here, it seems “Multi-Active Satellite ETL/ELT code is significantly more complex than that of a standard satellite and using it inappropriately could lead to serious inefficiencies”. Does anyone have any example of this? To be more clear, what are the challenges that can arise (both in general and in downstream models) when implementing MAS?

2

Please refer to this post on how I have implemented MAS with AutomateDV and DBT in our project environment. Hope it is helpful!

1 Like
3

This might help too, The Different Grains of Multi-Active Records. | by Patrick Cuba | The Modern Scientist | Medium