The second method to solve the problem is creating the link table using generic keys.
Generic keys are nothing but the combination of primary keys and a symbolic key, which represents several or all values of the field. Generic keys are different from composite keys; you should not get confused between these two. Composite key is just the concatenation of two or more fields and each link value represents one to one relationship of the values, whereas the generic key contains primary key along with the symbolic key, which represents one to many relationships amongst the values of the field.
For example, the generic keys look as follows:
Product_ID &’_’&’<Any>’ as %ProductKey
Null() &’_’&Customer_ID as %CustomerKey
Let us try to ...
