Setting the Parameters for Data Load Rules

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

Table 44. Parameters for Data Load Rules

ParameterValue
UserUsername
PasswordPassword or –f:Password file name
IMPORT_FROM_SOURCEY or N
EXPORT_TO_TARGETY or N
EXPORT_MODE

Essbase and Planning applications export modes:

  • STORE_DATA

  • ADD_DATA

  • SUBTRACT_DATA

  • REPLACE_DATA

  • OVERRIDE_ALL_DATA

The 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

START_PERIOD_NAMEPeriod Name or POV if the POV specified period value is retrieved from the period profile.
END_PERIOD_NAMEPeriod Name or POV if the POV specified period value is retrieved from the period profile.
SYNC_MODESYNC / 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.