cimt-ag / data_vault_pipelinedescription

A concept and syntax to provide a universal data format, for storing all essential informations, that are needed to implement or generate a data loading process for a data vault model.
https://www.cimt-ag.de/leistungen/data-vault-pipeline-description/
Apache License 2.0
3 stars 0 forks source link

Change implicit relation of satellite mappings to more likely behaviour #271

Open mattywausb opened 4 months ago

mattywausb commented 4 months ago

Currently satellite content (or any content) will be mapped to all parent relations(key sets), when the mapping is the only one for the column and no relation(key set) is declared.

It is less likely for content to belong to multiple key sets, therefore declaration of belonging to multiple key sets must be explicit(*). Without declaration, a content mapping belongs to the unnamed key set or the key set of the parent, when there is only one.

This differs from key mappings, where no declaration of key set means a belonging to all key sets. (Implicit *)

0.6.1

0.6.2

mattywausb commented 4 months ago

For satellites

For hubs/link content the same rules apply but the key set is that of the own table.

Scenarios:

Check scenarios: