Defining Identifiers

Define identifiers to indicate which schema attributes become keys in the destination table.

1. Either:
   • Right-click an ESP Schema and choose New > Identifier, or
   • (Primary identifiers only) On the ESP Schema Properties sheet, select the Attributes tab, and click the Primary Identifier column (the narrow column with the header P) for each attribute that is part of the primary identifier. Skip the remaining steps.
     Note: In the ESP Schema Properties Attributes tab, a checkmark in the P column indicates a primary identifier.
2. Select the General tab in the Identifier Properties sheet:
   1. (Optional) Set the identifier name.
   2. For a primary key, select Primary Identifier.
3. On the Attributes tab in the Identifier Properties sheet, enter the fields that identify the schema.