You must create column mappings for each column header in the import definition so that imported data matches the corresponding data column format in the staging area or target system. You can search for the objects and properties found locally or add new objects and properties using free text, then create the new mappings to match the target system objects and properties.
There are four types of column header mappings you can create for each column header.
-
When a column mapping has been added successfully, a check mark displays in the Has Mapping column next to the column header mapping in the main window. The options available for the column mapping vary based on the type of column header mapping used.
-
The object, property, relationship, and relationship property mapping names can include underscore and alphanumeric characters.
You can also create the following types of column mappings for each column header in the import definition using interface definitions: