Hi Raphael,
first of all, the record source should not be part of the business key. It should be there for debugging purpose only. You can however, add a field to the composite key to reflect the source system. This has been discussed on p age 124 of our book (Building a Scalable
Data Warehouse with
Data Vault 2.0).
In the end, the idea is that the
Hub integrates the data from your
satellites using the business key.
You should consolidate your keys using a same-as-
link (page 129).
Hope that helps,
Michael