Re: Should I use the qvc.LinkTable subroutine for my synthetic key case?
The issue of the small example hereabove seems to be fixed with the qvc script adjustment. But after enlarging my example it seems qvc does not create the linktable that I would expect. When making selections the qvc created linktable cuts of parts of the model that should be in the selection set.
In the new example I compare 3 cases
- a linktable created with joins
- a linktable created with a where clause( Not exists)
- a linktable created with qvc.linktable subroutine