Customizing Attributes and Attribute Groups

You can create an attribute or an attribute group through the user interface.

For more details on creating attributes or attribute groups, refer to the TIBCO MDM User’s Guide.

You cannot modify a pre-defined attribute in a repository through the user interface. To modify the size or length of a pre-defined attribute, modify the metadata of the attribute in the database.

Procedure

  1. Navigate to the repositories screen.
  2. View the repository, and modify the attribute length.
  3. Save the repository.

Result

The new length of the attribute is shown on the user interface. You do not need to change anything on the user interface while modifying the repository.

Note: Make sure that both the above SQL entries have the same size for length.

For repositories that have user-defined table names and custom database column names for attributes, the statements are:

  • ALTER TABLE <table name> MODIFY (<DB_COLUMN_NAME> VARCHAR2(10));
  • UPDATE CATALOGATTRIBUTE set ATTRIBUTELENGTH=10 where CATALOGID=<repository ID> and NAME='<ATTRIBUTE-NAME>';