I have a source system which aggregates for us all the marketing costs which we spent on the market.
They provide us with an export where I can select some dimension and facts.
Of course I could publish these data directly into my data mart. But I wonder how such aggregated data is ingested into a data vault. Some dimensions are fit to treat them as hubs. Others not.
And when I change some rules in the source, the existing data is void and needs to get replaced.
How do you ingest aggregated date?