1. Administrator's Guide
  2. Batch Processing
  3. Working with Batch Scripts
  4. Executing the Batch Script to Import Mapping Rules
  5. Setting the Parameters to Import Mappings Rules

Setting the Parameters to Import Mappings Rules

The parameters used to execute a batch script for importing mapping rules:

Table 6-5 Parameters for Data Load Rules

Parameter Value
USER_NAME Username
ENCY_PASS Password or –f:Password file name
LOCATION_NAME Location Name
DIMENSION_NAME Name of the dimension
File_PATH Directory from which to import source files.
Replace

Import mode load method:

  • A—Append

  • R—Replace
Validate Y or N
SYNC_MODE SYNC/ASYNC

  • SYNC—Process runs immediately and control returns when process completes.

  • ASYNC—When the ODI job is submitted, control returns. The load process continues to execute in ODI.

Note:

When using the importmapping.sh utility on Linux to import Oracle Hyperion Financial Data Quality Management, Enterprise Edition mappings, and you receive the following error: "String index out of range: -1", reference the directory like this: ./importmapping.sh admin welcome1 EBS_HFM_LOC account \/app\/EPM\\/import\/FDMEE\/FDMEE_Mapping_Account-PROJMGN.txt REPLACE N SYNC . Then make sure that the file is in Unix format and not in windows format. Run dos2unix to convert the file and then reload.