Within Identity Manager version 6.x and below, this used to be possible by setting the "Column Format" to "Unique" (as seen below). However, in more modern versions of Identity Manager, this is no longer possible. How can the same results be achieved?
In Identity Manager version 7.x and Above, a new Table Property has been added, called "Multi-Column Uniqueness". To force the column of a table to use a Unique Value, simply:
1. Open Designer
2. Navigate to "One Identity Manager Schema"
3. Under "Tables" | "Type: Table", select the table in question
4. Click on the task "Show Table Definition"
5. Select the name of the Table from the top of the Columns list, and the Table Properties will appear:
6. Under the tab for "MultiColumn Uniqueness", click the "New" icon
7. Provide a name under the "Unique Group"
8. Select the tables that you want to have unique values for, and if necessary, check the "Ignore Blank Values" box.
9. Once complete, commit the changes to the Database, and compile.