31.3.1 Execute SCDs through Seeded Batches

Other Results Dimension SCDs can be executed by executing task present in the SCD batch FSDFINFO_DATA_FOUNDATION_SCD.

Following steps will help you to execute the batch:

  1. Navigate to the Batch Execution screen.
  2. Select the seeded batch
    • FSDFINFO_DATA_FOUNDATION_SCD for target Dimension tables
    • FSDF_SOURCED_RUN for target Fact tables without RUNSkey
    • FSDF_EXE_RUN for FCT_SECURITIZATION_POOL which consists of RUNSkey.
  3. Select the AS_OF_DATE for which source customer information is required to be loaded into the table.
  4. Click Execute Batch.
  5. Monitor the status of the batch from Batch Monitor screen of OFSAAI.

    Note:

    While executing through batch, the RUN Skey will be defaulted to -1.