J.2.1 Executing Incremental T2T

To load the data from one table to another table (insert new rows in stage table), follow these steps:

  1. Navigate to Common Object Maintenance, select Operations, and then select Batch Maintenance to display the Batch Maintenance screen.
  2. Select DM_REGISTER_LOAD_RUN seeded batch for Batch ID and click Add to display the Task Definition page.
  3. Enter a Task ID and Description.
  4. Select TRANSFORM DATA for Components.
  5. Enter the following details:
    • Datastore Type: Leave the default value of “EDW”
    • Datastore Name: Leave the default value
    • IP Address: Leave the default value
    • Rule Name: fn_registerloadrun
    • Parameter List (Load Run Name, Load Purpose, Load Type)
  6. Click Save.
  7. To execute the batch, click the Batch Execution option under Operations. Select the DM_REGISTER_LOAD_RUN batch and select the corresponding check-box.
  8. Click Execute Batch. A message is displayed: Batch Triggered Successfully. Click Ok.
  9. Navigate to Batch Monitor, select the Batch ID click on Start Monitoring and verify if the Batch Run is successful.
  10. Connect to the database and verify if the entry is made into the REV_LOAD_RUN_MASTER table with a new Load Run ID.
  11. From the Batch Maintenance screen, select the seeded batch DM_REGISTER_LOAD_DETAILS and click Add to open the Task Definition page.
  12. For the Parameter List, enter the Stage Table Name, Load Run ID, Load Run Name, and Type Of Load (I).
  13. Click Save.
  14. Navigate to Batch Monitor, select the Batch ID click on Start Monitoring and verify if the Batch Run is successful.
  15. Verify the REV_LOAD_RUN_DETAILS table for the entry with the latest Load Run ID.
  16. Connect to the Database and verify in the REV_LOAD_RUN_MAP table for the seeded data.
  17. From the Batch Maintenance screen, select the seeded batch DM_POP_LOAD_RUN_MAP and click Add to open the Task Definition page.
  18. For the Parameter List, enter the Stage Table Name, Load Run ID, Load Run Name, and Type Of Load.

    Note:

    For each State Table, you should add different task and pass the Stage Table parameters.
  19. Click Save.
  20. Navigate to Batch Monitor, select the Batch ID, click Start Monitoring and verify if the Batch Run is successful.
  21. Connect to the Database and verify if a new entry is made with Load Run ID as 1 in the FSI_ACCOUNT_LOAD_RUN_MAP table.
  22. Execute and verify the incremental T2T.
  23. Navigate to Batch Monitor, select the Batch ID, click Start Monitoring and verify if the Batch Run is successful.
  24. Verify the processing table to ensure if the data is inserted.

    Note:

    The following T2Ts are present only in FTP:
    • OFSFTPINFO_T2T_FOR_FRA_PAY_INCR_LOAD
    • OFSFTPINFO_T2T_FOR_FRA_RCV_INCR_LOAD
    • OFSFTPINFO_T2T_FOR_OD_ACCOUNTS_INCR_LOAD
    • OFSFTPINFO_T2T_FOR_OPTIONS_CAPFLOOR_INCR_LOAD
    • OFSFTPINFO_T2T_FOR_OPTION_COLLARPAY_INCR_LOAD
    • OFSFTPINFO_T2T_FOR_OPTION_COLLARRCV_INCR_LOAD
    • OFSFTPINFO_T2T_FOR_STG_LC_GUARANTEES_INCR_LOAD
    • OFSFTPINFO_T2T_FX_SWAPS_CONTRACTS_INCR_LOAD
  25. Update the REV_LOAD_RUN_MASTER table with Status as Completed. To update, run the following SQL query:

    UPDATE rev_load_run_master SET LOAD_RUN_STATUS = 'Completed' WHERE Mis_Date = 'DD-MMM-YYYY' AND Load_Run_Name = '<LOAD_RUN_NAME>' and LOAD_RUN_ID = n ;