Indexes are defined as constraints on the Model view in ODI Studio. To make a field unique follow one of the two alternatives listed below.
PRIMARY KEY
Define the Index as a Primary Key constraint object on the Models area within the design view
Add the unique columns on the Columns tab
In the Control tab make sure the constraint is active and marked to be defined in the database for both flow and static control checkboxes
Review that the correct settings are configured in the Flexfields tab
ALTERNATE KEY
Define the constraint object for your table as an alternate key in the ODI models area
Add the unique columns on the Columns tab
In the Control tab make sure the constraint is active and marked to be defined in the database for both flow and static control checkboxes
Review that the correct settings are configured in the Flexfields tab
