IM Relationship Resolution Information Center, Version 4.2

Creating data mappings

A data mapping maps UMF data to the corresponding tables and table columns in the entity database. A new data mapping is required when incoming data with new UMF tags will be processed by the system.

Before you begin:
If this data mapping maps data to multiple tables, it is necessary to check that the tables will be inserted in the correct load sequence during pipeline operations. If the table does not exist in the dictionary, you must add the new table to the dictionary to be able to create a data mapping for the UMF and the table.
Procedure:
  1. Click the Setup button.
  2. Click the UMF button.
  3. Click the Data Map tab.
  4. From the Segment drop-down, select the UMF segment where you want to add a new data mapping to a table.
  5. From the Table drop-down, select the UMF segment table where you want to add a new data mapping.
  6. Complete one of the following steps:
    • To create a new data mapping, click the New button.
    • To create a data mapping based on an existing data mapping, select a data mapping from the list, and then click the Clone button.
  7. If this is a new segment, type the name of the UMF segment into the Segment field.
  8. Select the desired database table from the Table drop-down list
  9. In the Table Column field, type the name of the database table column to which you want to map the UMF data path to.
  10. From the Field Type drop-down, select the appropriate field type that represents the field type of the table column in the database.
  11. From the Data Type drop-down, choose the appropriate data type that represents the value of the data.
  12. In the UMF Data Path field, enter the UMF tag.
  13. From the Update Method drop-down , choose the appropriate update method to determine which value, between the inbound value and the previously stored value, will be retained.
  14. In the Status field, from the drop-down list, choose the appropriate status of the data mapping.
  15. Click the Save button.


Feedback

Last updated: 2009