11 Appendix A - Load Run IDs for T2Ts

You can load the data into OFSAA using the OFSAA T2Ts.

OFSAA Data Model includes Load Run Identifier as part of the primary key for staging tables. This enables data to be stored for multiple load runs for any date. OFSAA Data Model also has a table to maintain master information about Load Run and can be used for identifying or filtering Load Runs during Run execution within OFSAA.

Before loading data into the staging table, generate a Load Run Identifier to stamp the records from the source. These records can be a complete snapshot or can be partial or Incremental Data too. This Load Run Identifier can be generated by calling the function in the OFSAA Atomic Schema named fn_register_load_run (Batch name: DM_REGISTER_LOAD_RUN). The function expects some input parameters (as mentioned in section Incremental T2Ts) and returns a unique Load Run Identifier to the calling program.

For OFS HM applications, in the SETUP_MASTER, the V_COMPONENT_VALUE is seeded with the EPM_LOAD_RUN_ID equals to 0 by default.

The following process flow diagram illustrates the Load Run ID for the T2T process.

Figure 11-1 Load Run ID for T2T Process Flow