33 Load Run IDs for T2Ts

You can load the data into OFSAA processing or reporting tables using the OFSAA T2Ts.

OFSAA Data Model includes Load Run Identifier as part of the primary key for a set of staging tables. This enables data to be stored for multiple Load Runs for any date. Hence it helps the customer to apply the adjustments to the existing data incrementally OFSAA Data Model also has a table to maintain master information about Load Run and can be used for identifying or filtering Load Run 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 Load Run ID Registration Process.

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

Figure 33-1 Load Run ID for T2T Process Flow


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 Load Run ID Registration Process 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 Load Run ID Registration Process