Create dimtable based on two data sources

Hi,

I have 2 different data sources:

1) contains, amongst other things, employee name and turnover

2) contains employee name (but written differently)) and wage costs and a cost centre

I would like to create a dim table based on data source 1, because this adds newest employees first and therefore I know I have all the employees. It happens that wage costs are added later in the process and is therefore never the first to be complete.

Basiscally I need:

Employee name general

Employee name according to datasource 1

Employee name according to datasource 2

Cost centre number

That way I can communicate between the two fact tables.

I thought of copying datasource 1 as a dimtable and eliminating all columns except the employees name as a starting point. New data automatically adds new employees. After that adding columns, but that can't be a manual input I think?

Does anybody have a suggestion on how to combine these two to a dim table?