To create write-back mappings:
On the Workflow tab, under Data Load, select Data Load Rule.
Enter the Location Name or click
to navigate and select the location.
Choose the type of mapping by selecting either the Explicit tab, Between tab, Multi-Dimension, or Like tab.
Explicit—The source value is matched exactly and replaced with the target value. For example, the source value, “ABC” is replaced with the target value, “123.” “Explicit” write-back mappings are created the same for data load and data load to write back rules. See Creating Mappings Using the Explicit Method.
Between—The range of source values is replaced with one target value. For example, a range from 001 to 010 is replaced with 999. “Between” write-back mappings are created the same for data load and data load to write back rules. See Creating Mappings Using the Between Method.
In—In mappings enable a list of nonsequential source accounts to be mapped to one target account. In this case, multiple accounts are mapped to one account within one rule, eliminating the need to create multiple rules (as is required for an Explicit map).
Like—The string in the source value is matched and replaced with the target value. For example, source value Department is replaced by Cost Center A. See Creating Mappings Using the Like Method.
Write-back mappings provide a means to remove or strip characters that were added during the data load process. "Like" write-back mappings are created like a reverse data load.
Multi-Dimension—Define member mapping based on multiple source column values.
Tip: | You can click Refresh Values to refresh the list of segment or chartfield values that appear in the drop-down list from the source system. This is especially helpful when creating “Explicit,” “Between,” “Like,” and “Multi-Dimension” mappings for data load rules to write back. |