The Configure Data Mapping dialog allows you to configure settings in a selected source-target configuration file.
File panel
The Data Assistant file properties define the active source-target configuration file and enable you to further configure the source dataset, target dataset, and replace settings.
The following Data Assistant methods can be configured in your data migration project:
Property | Description |
Source-Target Configuration File | The active source-target configuration file for Data Mapping. |
Source Layer | The path to the source layer for the active configuration file. |
Replace By Field Value | When enabled, defines the selection query for the target layer that will be used when the Replace Data tool is executed. |
Target Layer | The path to the target layer for the active configuration file. |
Fields panel
The Data Assistant field methods define the actions to occur when migrating data from a source dataset to a target dataset. They can be used to populate new values in the target dataset or perform more advanced field mapping that may be necessary when the target dataset has a different data structure.
The following Data Assistant methods can be configured in your data migration project:
Method | Description |
Copy | Copy source field values to target fields. |
Default Value | Sets a default value for a field. |
Value Map | Set target values based on source value. |
Change Case | Change the case of the source text string. |
Concatenate | Concatenate source values into a string. |
Left | Extract a number of characters from the left. |
Right | Extract a number of characters from the right. |
Substring | Extract a set of characters from a string. |
Split | Split a string into parts and use one part. |
Conditional Value | Construct an if/else statement. |
Domain Map | Load and map domains values. |