Loading source system data

Loading the source system data for the integration is done via custom SQL scripts or importing from a CSV file to the staging tables.

Placeholder elements are generated when the fact data detects a need for the element. All other dimension elements are typically maintained by the ID from the source system. In the case of placeholder elements, these are incremental unique identifiers and the names, along with other properties are stored as cell values. Placeholder elements are generated for these dimensions: BPDNO, WBD_BASEDON_BENEFITCOST, WBD_BENEFITCOST, WBDACTION, WBDBC_RANGE, WBDPHASING, WBDPROGRESSION, WBDSG_STEP, WBDSG_TABLE, and WBDSG_GRADE.

  1. Start Microsoft SQL Server.
  2. Run the delivered stored procedures to load data into these tables in the DEPMInteg database:
    Table name Description
    DAT_WBDSG_TABLE_STAGE Salary
    DAT_WBDSG_GRADE_STAGE Salary grade
    DAT_WBDSG_STEP_STAGE Salary step
    DAT_PROGRESSION_STAGE Progression rules
    DAT_PROGRESSIONDATA_STAGE Progression rule data
    DAT_ATCDATA_JOB_STAGE Jobs
    DAT_ATCDATA_POSITION_STAGE Positions
    DAT_ATCDATA_EMPLOYEE_STAGE Employees
    DAT_ASSIGNMENT_STAGE Position assignments
    DAT_BENEFITCOST_STAGE Benefit costs
    DAT_BENEFITCOST_BASEDON_STAGE Benefit costs based on
    DAT_BENEFITCOSTDATA_CAPS_STAGE Benefit cost caps
    DAT_BENEFITCOSTDATA_RANGE_STAGE Benefit cost range
    DAT_BENEFITCOST_JOB_ACTION_STAGE Job actions
    DAT_BENEFITCOST_POSITION_ACTION_STAGE Position actions
    DAT_BENEFITCOST_POSITION_ACTION_STAGE Assignment actions
    DAT_ALLOCATION_STAGE Allocations