15.6.1 Complete Snapshot Load Scenario

To enable the Data Load into Results table from staging using the Load Run concept in case of Full Snap Shot, You can use the following Task Level Parameter in the T2T Filter condition and can pass the load run id to be passed in Batch Framework or Run Framework

For example: FCAS T2T for Stage Loan Contracts

• "Modify Filter Condition inside T2T:

  Filter Conidtion to be used in T2T: The highlighted condition required to be added in T2T

  Filter : UPPER(STG_LOAN_CONTRACTS.v_gaap_code)='USGAAP' AND STG_LOAN_CONTRACTS.fic_mis_date=$MISDATE AND STG_LOAN_CONTRACTS.N_LOAD_RUN_ID='[LOADRUN]'

• "Modify the Corresponding Batch Task Each Time with Load Run Idxxx
  1. Select Batch, Task (T2T_STG_LOANS_CAS)
  2. Click Edit.
  3. Add Highlighted Condition in Default Value and Save (Each Time we need to provide the Load Run ID which are supposed to use. Here in the below example we are using 1)

     [DRCY]=USD,[LOADRUN]=1

Execute the batch after this change; it will load the Result table with the given Load Run Id Records Modify the Corresponding Process Task of a Run Each Time with Load Run Id

1. Select Process, Click Edit.
2. Choose the Components, Select the Object (T2T_STG_LOANS_CAS) and Click Components
3. Click the Yellow Drop Button near the T2T
4. Add the Highlighted Condition with the text, and Save : "DRCY","USD","LOADRUN","1"

Fire the Run after this change. It loads the Result table with the given Load Run ID Records.