IM Relationship Resolution Information Center, Version 4.2

Adding fields to entity database tables

You may need to add a new field to an existing entity database table to accommodate a new data.

About this task:

A new field can be added to an existing table when a new UMF segment does not require an entirely new table.

Adding fields to an existing entity database table does not allow resolution on the new data, it is just a place to store data.

It is recommended that you should use a test database when verifying new configurations before applying those new configurations to your production environment.

It is recommended to use existing tables and fields to classify new data if at all possible.

Procedure:
  1. Add the new field to the appropriate database table.
  2. Create the data mapping for the new field in the console.
  3. Determine the appropriate DQM rules to apply to the new field and configure those rules through the console.
  4. Verify the new configuration by running known test data through a pipeline and checking the resultant log files.
    1. Verify the test runs without errors.
    2. Check for UMF Exceptions in console.
    3. Check log files nodename.Sql.Err.log and nodename.err for errors.
    4. Verify test results match the expected results.
    5. Check the UMF_LOG table to ensure all records load properly.


Feedback

Last updated: 2009