7 Dimension Loader

The Dimension Loader in the Data Foundation for Banking is a data ingestion tool that loads dimension data (members, attributes, and hierarchies) from staging tables into PBSM interface tables using a PMF pipeline. It supports structured loading via preparation tables and integrates with cloud services where the loaded data can be viewed. The Data File Specification is not applicable to Dimension Data Loaders. The file format and the file names are static in nature.

Purpose of the Dimension Loader

The Dimension Loader performs the following key functions:

  • Loads Dimension Members and their Attributes from the staging area into the Dimension Tables registered with the OFS Cloud Service framework.
  • Creates Hierarchies for Key Dimensions in the Cloud Service.
  • Loads Hierarchical Relationships between Key Dimension Members into the Cloud Service.

The following are the features of Dimension Loader:

  • Loading Simple Dimensions from Staging Tables.
  • Multiple Hierarchies can be loaded from Staging Tables.
  • Validations of Members and Hierarchies are similar to that of being performed within the Cloud Service Screens.

Pre-requisites

Before initiating the Dimension Loader:
  • Upload the Data Files containing dimension details.
  • Ensure that each file includes a valid Dimension Identifier for both key and simple dimensions.

System Components and Workflow

The dimension loading process involves the following stages:

  • Source Systems: These are the systems where raw and reference data is sourced:
    • Stage Dimensions Master: Stores raw dimension data received from upstream transactional or master systems.
  • Dimensions Reference: Contains metadata for validation and enrichment of staging data.
  1. Step 2: Launch Execution
    1. Navigate to Process Modeler → Dimension Loader in the Data Foundation for Banking UI.
      1. Open the Dimension Loader component.
      2. Select Execution Type.

        Figure 7-1 Dimension Loader - Process Orchestration


        Dimension Loader - Process Orchestration

      3. Enter the following:
        • Object ID (e.g., DIM_AMH_Load_20250131_1)
        • Application Params: 
          json
          {"FIC_MIS_DATE":"2025-01-31"}
        Run the component to begin data load for the selected.
        FIC_MIS_DATE

        Figure 7-2 Dimension Loader - Execution


        Dimension Loader - Execution

  2. ADS Connectors
    • Extract data from Preparation Tables
    • Apply additional formatting if needed
    • Transfer data securely to PBSM Data Schema
  • Reprocess failed loads
  • Investigate errors
  • Monitor success rates and traceability
  • File Format and Specification:
    • Data File Specification is not required for Dimension Loader.
    • File format and names are static and predefined within the framework.
  • Once the ingestion process is completed, start the PMF Execution process. For more information, see PMF Execution Process.