I have a question when to 'split' Entities:
A Source-Table contains dependend on several attributes more than one entities.
The business keys of the different hubs
are therefore composite-keys.
In my opinion is the correct way to source the complete table into the raw data vault
and then to split the entities into different hubs
in the business vault.
The current approach is to split the entities on the way from staging to the raw vault but in my opinion is here too much logic or better soft business rules in the loading of the raw vault, isn't it?