37.4 Backdated Run Execution using Latest Record Indicator (LRI) batch

A new Data Transformation batch UPDATE_BACK_DATED_DIM_LRI is created. This batch supports Backdated Run execution in the Latest Record Indicator (LRI) dimension table. The task in the UPDATE_BACK_DATED_DIM_LRI batch updates LRI Dimension Table for a given Dimension Table and for a given FIC_MIS_DATE. When this batch is triggered for a given FIC_MIS_DATE, the SKeys are updated with the new LRI flag value (F_LATEST_RECORD_INDICATOR = Y/N).

To execute Backdated Run using LRI batch, follow these steps:

1. Add the required data records to their Master table and for the required FIC_MIS_DATE. For example, added two records to STG_PARTY_MASTER. The resultant image is shown below.

   Figure 37-1 Sample of adding records for the backdated Run execution using LRI

   
   

   

   
   

   Note:

   Ensure that V_PARTY_ID is same in this step and the LRI batch execution step.
2. Execute the SCD batch to add the required records from Master table to its Dimension table with the required FIC_MIS_DATEs. For example, execute SCD batch to add records from STG_PARTY_MASTER to DIM_PARTY. The resultant data record in the DIM_PARTY is as shown below:

   Figure 37-2 Sample after executing the SCD batch for first record for the backdated Run execution using LRI

   
   

   

   
   
   • After adding the first record to DIM_PARTY for the FIC_MIS_DATE 1/1/2001, the flag F_LATEST_RECORD_INDICATOR associated with this data record is set to Y.
   • After adding the second record to DIM_PARTY for the FIC_MIS_DATE 1/1/2002, the flag F_LATEST_RECORD_INDICATOR associated with this data record is set to Y, and the flag

   Figure 37-3 Sample after executing the SCD batch for the second record for the backdated Run execution

   
   

   

   
   
3. In Batch Maintenance, add a Task for the LRI Dimension table. In the Parameter List field, mention the Dimension table name (‘DIM_TABLE_NAME’) for which Backdated Run using LRI must be executed. In this example, ‘DIM_TABLE_NAME’ = ‘DIM_PARTY’.

   Figure 37-4 Add Task for the LRI table

   
   

   

   
   
4. In the Batch Execution window, execute the UPDATE_BACK_DATED_DIM_LRI batch for different FIC_MIS_DATEs.

   Figure 37-5 Execute the LRI batch

   
   

   

   
   

   The following are the examples of data record after running the LRI batch with different FIC_MIS_DATEs:

   • The image depicts execution of the UPDATE_BACK_DATED_DIM_LRI batch for a backdated record for its FIC_MIS_DATE. Therefore, this record is the Latest Record. In the following image, the LRI batch is executed for the data record with historical FIC_MIS_DATE 1/1/2001. Therefore, the flag F_LATEST_RECORD_INDICATOR associated with FIC_MIS_DATE 1/1/2001 is set to Y. This data record is flagged as the Latest Record, and will be used as default by the system for all future transactions and processes.

     Figure 37-6 Sample data record after running the LRI batch with a different FIC_MIS_DATE

     
     

     

     
     
   • To change the default data selection, execute the UPDATE_BACK_DATED_DIM_LRI batch for the required data record for its FIC_MIS_DATE. In the following image, the batch is executed for the data record with FIC_MIS_DATE 1/1/2002. Therefore, the flag F_LATEST_RECORD_INDICATOR associated with this FIC_MIS_DATE 1/1/2002 is set to Y and this data record is now flagged as the Latest Record. This record will be used as default by the system for all future transactions and processes. The flag F_LATEST_RECORD_INDICATOR associated with the earlier default data record (with FIC_MIS_DATE 1/1/2001) is set automatically to N, indicating that the record with FIC_MIS_DATE 1/1/2001 is not the Latest Record anymore.

     Figure 37-7 Sample data record after running again LRI batch with a different FIC_MIS_DATE

     
     

     

     
     
5. Monitor the status of the batch in the Batch Monitor screen.