How to Create a Teradata Multiset Table in erwin Data Modeler?
MULTISET can be specified as an option under the "Row Control" field.
Please follow the below steps to specify the MULTISET option…..
1. On the Physical side of the mode, right click on the table and go to Table Properties:
2. On the " General" tab, set "Row Control" field and select drop down arrow to change "SET" to "MULTISET"
3. Click Close
When Forward Engineering, this will generate syntax such as the following...