I am getting a feed of. csv files containing attributes such as ROLE_1, ROLE_2, ROLE_3, etc. Does it make sense to unpivot them in the raw vault or in the business vault? Also, for each attribute set: role, specialty, qualification, is best to have a satellite for each one unpivoted running off the link?
Yes, into Raw Vault as long as they are intended to load to the same hub table