Key Design Decisions Why separate staging and intermediate? Staging models are a 1:1 mapping of source tables — clean types, renamed columns, nothing more. This means if a source changes, you fix it ...

-- The satellite table is constructed by joining the source data with the hub keys.