Hi all,
we have Raw Vault for non-banking industry and we are already using list of currencies as reference tables.
So we already have the reference codes in satellites.
We now need to load daily FX rates to Raw Vault to be able to handle currency conversions in data marts.
How would you recommend to model the daily FX rates in Raw Vault. Would you recommend to change currency to Hub and model FX rates as a Link?
Thanks!
I think, this question was answered by Michael Olschimke in today’s Datavault Friday: https://www.youtube.com/watch?v=2XtIecd4yD0
Some things should stay as Reference modelled data and pass the enrichments into consumption.
Why bother splitting ref data into hubs + sats if you end up having to join the two together when consuming the data… adds unnecessary complexity. There are better ways to manage ref data