best method to remove synthetic key

[Abhishekb]

Hi community,

The following script is giving the synthetic Key alert while loading.
Developer needs to remove synthetic key in script.
Script:
Sales:
Load Year, month, Date,Region,Amount from Sales_Date;
Budget:
Load Year,Month,Region,Budget_Amount as Amount from Budget_Data;

Which is the best method to remove synthetic key?

Remove Year and month columns in Sales table

Do the left join budget table into sales table

Concatenate the both table with flag and creating the Master calendar

Make a key with combination of Year,month and Region in both the tables

[vikasmahajan · Accepted solution]

Concatenate the both table with flag and creating the Master calendar should be a right answer.

[Abhishekb]

Hi @vikasmahajan 

Thanks for the solution.