Using the Parameters for Data Load Rules

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

Table 15. 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

For Essbase & Planning Applications export modes are:

  • STORE_DATA

  • ADD_DATA

  • SUBTRACT_DATA

  • OVERRIDE_ALL_DATA

For HFM Applications export modes are:

  • Accumulate

  • Replace

  • Mode

EXEC_MODE

  • Snapshot

  • Incremental

  • Full Refresh

LOAD_FX_RATEY or N
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 will return. The load process continues to execute in ODI.