Create dimtable based on two data sources

[lekkerbek]

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? 

[mohammedadnant · Accepted solution]

Hi @lekkerbek ,

Yes, as you said, you can append the 2 tables and then remove duplicate and remove other columns.

by this way you are creating a new table and this table will be master table, then make relationship of that 2 table with this new table.

Thanks & Regards,

Mohammed Adnan

www.youtube.com/taik18

[lekkerbek]

Thanks! I got it to work.