We use supernatural keys for tabular links … it’s such a pain tabular doesn’t support composite joins.
(please let me know if this is not best practices)
If we use supernatural keys for e.g. open sales orders (Company + SO), we’ll build a repository of orphaned keys over time as the open sales orders get closed and removed from the data warehouse.
Will this impact performance over time? Not sure … but I think it would be a nice feature if we could right-click a key store and get the option to delete orphaned keys (in both v20 and v21).
The alternative is of course to redeploy the key store and regenerate all required keys.
