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:
|
Validate | Y or N |
SYNC_MODE | SYNC/ASYNC
|
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.