The previous data model scenario is a typical scenario that occurs due to the presence of multiple fact tables. In this case,
SalesTarget are two fact tables and they share common dimensions. Star schema prefers one single fact table in the schema. This scenario can be resolved with the help of a link table.
A link table is a central table that will contain common fields from the two tables and therefore it creates one table and avoids synthetic keys.
The following steps are followed in the creation of any link table:
Autonumberfunction to make this key unique and numeric. This composite key will act as a key field to connect the link table ...