Allow Mapping of Utility Columns
Visibility is set to None by default for appended utility columns. However, the visibility setting can be configured to allow utility columns to be mapped if needed.
A System Administrator can set visibility for append utility columns on the Append Utility Columns page. Visibility determines whether fields display on the Field Mappings page in Map and can be mapped as Source fields, Target fields, or as both Target and Source fields. Visibility can also be set to None, indicating that the field does not display on the Fields Mappings page and is not mapped.
Field visibility can also be defined for Target fields. Refer to Set Field Visibility for Mapping for more information and for general information about the visibility setting.
Field defined as Append columns can be appended to all Target or Source tables, depending on how the fields are configured. Refer to Append Utility Columns to All Tables for more information.
NOTE: If a user deletes an append column, if it has already been synced with Map, the column still appears on the Target table. To remove the append column in this case, set the column to inactive.
To set visibility for appended utility columns in Target Design:
- Select Configuration > Append Utility Columns in the Navigation pane.
NOTE: The zSource column is installed with the platform and cannot be edited or deleted.
Select an option in the VISIBILITY list box.
NOTE: Values are:
- Both – Mapping for Source and Target
None – No mapping required for the field
- Source – Source only mapping
- Target – Target only mapping
NOTE: Natural fields cannot have a visibility set to None.
- Click Save.