How to dealing with synthetic keys?

[#1]

Hi guys,

I have four tables as below,the Subsidiary and the Model are dimension table and the Sales and Forecast are fact table,

how to dealing with these synthetic keys?

By the way, the shared key is the same color.

Thank you very much.

Regards,

[Gysbert_Wassenaar]

Consider consolidating the Sales and Forecast tables into one table. See this blog post: Fact Table with Mixed Granularity