Link DCK or MA satellite for modelling role/type information

Data Vault 2.0
1

Hey guys. Do you have any suggestions on right approach to model multiple possible values for role or type info for a specific link?
For example, A and B customers are related with relationship types “parent” and “payer” at the same time. Do I:

  1. create only A-B in the link and in MA satellite store A-B-parent and A-B-payer separatelly
  2. create A-B-parent and A-B-payer in the link (parent and payer being DCK)
  3. some third option?

Thanks!

2

I always avoid dep-keys in links, better to manage them in the satellite; it’s not an MSAT.

1 Like