Data Hub to Spoke Model Line Items or Subset
I am building a data hub and spoke models. Currently, I have:
- built a data hub with system shared lists. It holds flat lists that only consist of list items and list codes.
- used modules in the data hub to assign line items which act as parents, grandparents and other metadata to the flat lists.
- saved specific views to pull into the spoke model
My question is, when pulling data into the spoke model, should the line items (metadata) stored in the data hub be set up as list properties? Is this the most efficient way or should the line items from the data hub be formula driven in the spoke model?