Chapter 5. The Right Data Model Pays Dividends
In this chapter, we will cover the following key topics:
- Synthetic keys and why they're sometimes bad news
- Link tables
- Avoiding loops in the data model
- Simplify, simplify, simplify – never have subtables that you don't need
- Data islands, single calendars, and set analysis
- Avoiding problems with JOIN
Synthetic keys and why they're sometimes bad news
Whenever you create two or more tables that have two or more fields with the same name, QlikView creates a synthetic key table to join them.
Background
Old school logic has stated for a long time that Synthetic keys in the data model design are bad. This is not always the case, however, and in some cases, it is unavoidable.
How to do it
The best way to avoid Synthetic ...
Get QlikView Unlocked 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.