we have the concept of SourceSystemKey to identify where a record came from. that plus the business key of the table is all we need.

We have DimSourceSystem that we manually keep updated with system connection info and whether or not that system is enabled (every so often there will be a weather event that knocks out a line of business so we avoid that one until it is back online).