2 Fields in a Table linked to an independent table

[JonathanKelly]

I am combining multiple sources through concatenation to create one singular table.

Each source is for different types of works so they are held in independent locations on a database. Each type of work has a company ID associated with each job. However, one of the sources doesn't hold a company ID it holds a UID which is a specific ID that only that type of works use. I want to link both of these ID's to a Company Name table so that I can filter my data by company 

e.g.

3 Source tables:

Concatenated to the below;

I am trying to link the above with the below so that I can filter by company name

Note that there are some crossover of UID and Company ID - as such I am unable to just rename UID as Company ID.  

[marcus_sommer]

I would merge both ID's into a single ID field directly with a renaming by concatenating the tables + adding an extra source-field + combining these new ID and Source field to get a key-field. This means doing the same on the facts and the dimensions. If there are no further specific reasons I wouldn't include the origin ID fields.