1. Administrator's Guide
  2. Batch Processing
  3. Working with Batch Scripts
  4. Executing the Batch Script for Data Load Rules
  5. Setting the Parameters for Data Load Rules

Setting the Parameters for Data Load Rules

The parameters used to execute a batch script for data load rules are:

Table 6-2 Parameters for Data Load Rules

Parameter Value
User Username
Password Password or –f:Password file name
IMPORT_FROM_SOURCE Y or N
EXPORT_TO_TARGET Y or N
EXPORT_MODE

Oracle Essbase and Oracle Hyperion Planning applications export modes:

  • STORE_DATA

  • ADD_DATA

  • SUBTRACT_DATA

  • REPLACE_DATA

  • OVERRIDE_ALL_DATA

The Oracle Hyperion Financial Management application export mode:

  • Accumulate

  • Replace

  • Merge

  • Replace_By_Security
IMPORT_MODE

  • Snapshot

  • Incremental

  • Full Refresh

The file-based source system export modes:

  • Append

  • Replace
LOAD_FX_RATE Load exchange rate flag. Y or N
START_PERIOD_NAME Period Name or POV if the POV specified period value is retrieved from the period profile.
END_PERIOD_NAME Period Name or POV if the POV specified period value is retrieved from the period profile.
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.