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:
- Click the Setup button.
- Click the UMF button.
- Click the Data Map tab.
- From the Segment drop-down, select the UMF
segment where you want to add a new data mapping to a table.
- From the Table drop-down, select the UMF
segment table where you want to add a new data mapping.
- 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.
- If this is a new segment, type the name of the UMF segment into
the Segment field.
- Select the desired database table from the Table drop-down
list
- In the Table Column field, type the name
of the database table column to which you want to map the UMF data path to.
- From the Field Type drop-down, select the
appropriate field type that represents the field type of the table column
in the database.
- From the Data Type drop-down, choose the
appropriate data type that represents the value of the data.
- In the UMF Data Path field, enter the UMF
tag.
- 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.
- In the Status field, from the drop-down
list, choose the appropriate status of the data mapping.
- Click the Save button.