15.5.1 Register Load Run Details
Once you load the OFSAA Stage tables successfully using the load run ID which is generated from Load Run Map function, you need to register the load run details by calling the following function with the load type whether it was incremental or full snap shot.
Function - Register Load Run Details
Parameters - batch id, mis-date, load run name, load run id, stage table name, load type
Table 15-9 Register Load Run Details
| Parameters | Source Of Values | Example Values |
|---|---|---|
| Batch ID | Auto generated if you are using OFSAA Framework | OFSBFNDIN- FO_20150101_1 |
| MIS-Date | Input from Customer | 01/01/2015 |
| Stage Table Name | Input from Customer | STG_CASA |
| Load_Run_Id | Input from Customer | 1 |
| Load Run Name, | Input from Customer | FSDF_Load |
| Load Type | Input from Customer | S - Full Snap Shot I - Incremental |
Example:
Declare
Result number;
Begin
Result: =
fn_register_load_details('OFSBFNDINFO_20150101_1','20150101', 'STG_CASA',1,'FSDF_LOAD', 'I');
END;
This function populates a table named rev_load_run_details. The columns load type can have only 2 values, such as:
- "S - Complete/Full Snapshot
- "I - Incremental Snapshot
Table 15-10 Population of the REV_LOAD_RUN_DETAILS table
| LOAD_RUN_ID | MIS_DATE | STAGE_TABLE_NAME | LOAD_TYPE |
|---|---|---|---|
| 1 | 1-Jan-15 | STG_LOAN_CONTRACTS | I |