Using an Import Mapping Job Type

The Import Mapping job type enables you to import member mappings from a .CSV or .TXT file format.

The Import Mapping job type supports merge or replace modes, along with validate or no validate options for target members.

Import Mapping job type parameters include:

Table 12-15 Import Mapping Job Type parameters

Import Mapping Job Type Parameter	Description
Name	Select the name of the Data Integration location where the member mappings are to be loaded. Member mappings are specific to the location in Data Integration and are based on the select connection ("local" or "remote").
Dimension Name	Specify the dimension name for a specific dimension to import, such as ACCOUNT, or ALL to import all dimensions.
File Name	The file and path from which to import mappings. The file format can be .CSV, .TXT, .XLS, or .XLSX. The file must be uploaded prior to importing, either to the inbox or to a sub-directory of the inbox. Include the inbox in the file path, for example, inbox/BESSAPPJan-06.csv
Import Mode	Specify the import mode: MERGE to add new rules or replace existing rules, or REPLACE to clear prior mapping rules before importing. Available options: MERGE—Add new rules or replace existing rules. REPLACE—Clear prior mapping rules before import.
Validation Mode	Specify whether either to use validation mode. Specify Yes to validate the target members against the target application. Specify No to load the mapping file without any validations. Note: The validation process is resource intensive and takes longer when the validation mode is Yes.

Here are sample Import Mapping job type parameters where the "Entity" dimension at the FCCSAPPI_ImpExp_Maps location will be loaded as a text file to the inbox.