4.3 SATELLITES An apt definition in the Oxford dictionary summarises the satellite table’s place in data vault, “something that is separated from or on the periphery of something else but is nevertheless dependent on or controlled by it.” A satellite contains the descriptive details about the artefact it is adjacent to. If the satellite is adjacent to a hub table then it will contain the change-tracked descriptive details about a single business entity in a hub. If the satellite is adjacent to a link table, then it will contain the change-tracked descriptive details about a relationship in a
...more
