1. User Guide
  2. Appendix A - Load Run IDs for T2Ts
  3. Incremental T2Ts

Incremental T2Ts

Incremental T2Ts are introduced to support the incremental load of data for a particular MIS date. For loading the incremental T2Ts, follow these steps:
  1. Verify the REV_LOAD_RUN_MAP_SETUP table for the seeded data.
  2. Generate the Load Run ID.
    • Seeded Batch: <infodom>_DM_REGISTER_LOAD_RUN
    • Input: Load Run Name, Load Purpose, Load Type
    • Output: generates Load Run ID in REV_LOAD_RUN_MASTER table
  3. Register the Load.
    • Seeded Batch:<infodom>_DM_REGISTER_LOAD_DETAILS
    • Input: Stage Table Name, Load Run ID, Load Run Name, Type Of Load
    • Output: REV_LOAD_RUN_DETAILS
  4. Load Data to stage table with generated Load Run ID.
  5. Execute the batch to load the data to the FSI_ACCOUNT_LOAD_RUN_MAP table:
    • Seeded Batch:<infodom>_DM_POP_LOAD_RUN_MAP
    • Input: STAGE_TABLE_NAME, LOAD_RUN_ID, LOAD_RUN_NAME
    • Output: FSI_ACCOUNT_LOAD_RUN_MAP
  6. Execute the incremental T2T to load the data into the processing table.
    • Input: FSI_ACCOUNT_LOAD_RUN_MAP, Stage Table
    • Output: Processing Table
  7. Mark the load manually as completed by updating the REV_LOAD_RUN_MASTER table.