1. User Guide
  2. Dimension Loading Process
  3. Executing the SCD Component

5.7 Executing the SCD Component

(Required) <Enter a short description here.>

To execute the SCD component from Operations module of OFSAAI, create a batch according to the following steps:

Note:

For a more comprehensive coverage of configuration and execution of a batch, see Oracle Financial Services Advanced Analytical Applications Infrastructure User Guide Release 8.1.2.0.0
  1. From the Home menu, select Operations, then select Batch Maintenance.
  2. Click New Batch (?+? symbol in Batch Name container) and enter the Batch Name and Description.
  3. Click Save.
  4. Select the Batch you created in the earlier step by clicking the check box in the Batch Name container.
  5. Click New Task (?+? symbol in Task Details container).
  6. Enter the Task ID and Description.
  7. Select Run Executable, from the Component ID list.
  8. Click Parameters. Select the following from the Dynamic Parameters List and then click Save:
    • Datastore Type ? Select the appropriate datastore from the list
    • Datastore Name ? Select the appropriate name from the list
    • IP address ? Select the IP address from the list
    • Executable ? scd,<map ref num>

    Note:

    Example:

    scd, 61 (Refer the following sections for details).

Wait: When the file is being executed you have the choice to either wait till the execution is complete or proceed with the next task. Click the list box of the field provided for Wait in the Value field to select 'Yes' or 'No'. Clicking Yes confirms that you wish to wait for the execution to be complete. Clicking No indicates that you wish to proceed.

Batch Parameter: Clicking Yes would mean that the batch parameters are also passed to the executable being started; else the batch parameters will not be passed to the executable.

Note:

Always select Y in Batch Parameter.

For the Parameter Executable earlier mentioned, the map ref num values are

  • ?1 (if you want to process all the dimensions). The Executable parameter mentioned earlier would be scd,-1
  • If you want to process for a single dimension, query the database table SYS_TBL_MASTER and give the number in the map_ref_num column for the dimension you want to process. These are the ones which come seeded with the install.
  • Execute the batch from Batch Execution by choosing the batch created following the steps mentioned in the preceding sections for a date.

    Note:

    A seeded batch FSDFINFO_DATA_FOUNDATION_SCD is provided which consists of all the required dimensions as different tasks that are part of SCD.