Entity attributes with attributes

Data Vault 2.0
1

Hello everyone,
I am new to data engineering and data vault so I need help for the use case I have stumbled upon.

Let’s say that I have a business entity A that has been modeled as a hub. To each record of the entity A is associated one or more entities B that cannot have their own hubs since they are “weak” business entities and their existence depends only on A and are not related to anything else. Each entity B has its own set of attributes and it is related to one or more entities C that have their own set of attributes. C can’t have its hub because it exists to the sole purpose to add details to entity B that adds details to A.

How should I model this? Should I just create a multi-active sattelite for entity A that tracks all attributes of B and C? Should I us insted two multi-active satellites one for B and one for C? Are there better solutions

2

Hi AlPetMaggioli

I think in my head you can use 2 MASats like you suggest, though I’d probably still be interested in modelling the hubs out as a simple child dependency. But as you say weak hubs come with their own problems too. Realistically these are all attributes of Entity A so MASats makes sense in terms of methodology.

Frankie

3

Hi Frankie

Thanks for your reply. I got more information about my source data and basically when entity C gets a new record, B gets a new record too so they both update at the same time. Due to this behavior I built one MASat for storing both attributes from B and C