Create a crosswalk to map code values in a source code list to code values in a target code list from same or different reference data sets. Value mappings provide a way to translate code values in one code list to code values in another code list. You can specify internal ID and alias for a crosswalk.
Note: Effective in the April 2025 release, the ability to specify a unique internal ID and alias for a crosswalk is available for preview.
Preview functionality is supported for evaluation purposes but is unwarranted and is not supported in production environments or any environment that you plan to push to production. Informatica intends to include the preview functionality in an upcoming release for production use, but might choose not to in accordance with changing market or technical circumstances. For more information, contact Informatica Global Customer Support.
1Click New and select Crosswalk.
The New Crosswalk page appears and displays the Summary tab.
Note: You cannot configure the general properties. A crosswalk inherits its general properties from the source and target reference data sets.
2In the Source Reference Data Set field, select the reference data set that contains the code list you want to map.
3In the From Code List field, select the source code list.
The crosswalk is associated with the source code list.
4In the Target Reference Data Set field, select the reference data set that contains the code list you want to map to the selected source code list.
5In the To Code List field, select the target code list
The target code list contains code values that you want to map.
6Configure the additional properties fields.
Note: Crosswalks inherit the name from the reference data set.
The following table lists the properties that you can configure for a crosswalk:
Additional Property Field
Description
Name
Display name of a crosswalk.
Internal ID
Required. Unique identifier of a crosswalk, limited to a maximum of 45 characters. You can use alphanumeric characters and underscores. After you save an asset, you can't edit the internal ID.
Note: You can't specify internal IDs for existing assets.
Alias
Alternative identifier for a crosswalk, limited to a maximum of 70 alphanumeric characters. After you save an asset, you can edit the alias.
Description
Short description of the crosswalk. The description cannot exceed 4000 characters.
Confidentiality
Confidentiality level of the code list inherited from the reference data set. The confidentiality levels are confidential, internal, restricted, and public.
Status
State of a crosswalk in the life cycle.
Note: If you do not see options in the list, configure your system reference data values. For more information, see Adding values to system reference data.
Effective Date
Date from when the status is effective.
Approved by
User who approved a crosswalk.
Approved on
Date of approval.
7Click Save.
A new crosswalk is created. The crosswalk name displays the source code list and target code list. If the target reference data set is different from the source reference data set, the crosswalk name displays the name of the target reference data set adjacent to the target code list.
In the Explore panel, you can view the crosswalk name appended with the target reference data set name when the source and target reference data sets are different.
Note: Users with a Reference Data Management Basic Edition license can create crosswalks only between the default code list and another code list of the same reference data set.