How to Create a Teradata Multiset Table in erwin Data Modeler?
MULTISET can be specified as an option under the "Row Control" field.
Steps:
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...
