The problem with the concatenate option is that it works well when the granularity of two tables are same, but when the granularity of the tables is not same, it is not suitable. So in such cases, the link table option is used to remove the synthetic keys.
In this method, we create a logical table also called as link table. The link table contains keys which will link the fact tables and the common fields from the fact tables.
Let us see an example. We take the following image:
As you can see in the previous screenshot, there are three tables, that is, sales, budget, and purchase. The granularity of all three tables is different, ...
