Link table
The previous data model scenario is a typical scenario that occurs due to the presence of multiple fact tables. In this case, Orders and 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.
Link table essentials
The following steps are followed in the creation of any link table:
- Create a composite key in all the concerned fact tables. Use the
Autonumberfunction to make this key unique and numeric. This composite key will act as a key field to connect the link table ...
Get QlikView Essentials now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
