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?