Load Data in FCC_ER_OUTPUT Table

4.4.4 Load Data in FCC_ER_OUTPUT Table

Job

The ER_Run_Full_Data_Output.sh job executes the SQL procedure that joins the following staging output tables and populates data for the split and merge UI:

STG_PARTY_MASTER
STG_PARTY_DETAILS
STG_PARTY_EMAIL_MAP
STG_PARTY_PHONE_MAP
STG_ADDRESS_MASTER
STG_PARTY_ADDRESS_MAP
STG_CUSTOMER_IDENTIFCTN_DOC

Note:

If you want to perform slicing for the initial input data to run Day 0 batch, it is recommended to run

ER_Create_And_Load_Data_Into_Index.sh,
                    ER_Run_Bulk_Similarity_Job.sh,

and ER_Run_Data_Survival_Engine.sh jobs for all slices. The Output Tables are expected to have the resolved entities at the end of this process. At this point, ER_Run_Full_Data_Output.sh job can be executed for bringing the entire data across all slices into the output table.

Steps

Note:

To re-run this job after a failure, the value of the n_run_status column in the fcc_batch_run table in Compliance Studio Schema should be changed to 6 for the respective n_run_skey.

Navigate to <COMPLIANCE_STUDIO_INSTALLATION_PATH>/deployed/ficdb/bin directory.
Run the following command:
```
nohup ./ER_Run_Full_Data_Output.sh "<PIPELINE_ID>"
"<ER_SCHEMA_WALLET_ALIAS>" "<FIC_MIS_DATE>" "<BATCH_GROUP>"
"<LOAD_TYPE>" "<RUN_TYPE>" &
```
Note:
<BATCH_GROUP> refers to the FCC_PROCESSING_GROUP table in the Compliance Studio schema.

FSDF 8128 version: nohup ./ER_Run_Full_Data_Output.sh "CSA_8128" "ER_SCHEMA_PP_ALIAS" "20151210" "CSA_812" "FullLoad" "RUN" &

For more information about parameters, see the Parameters for Entity Resolution Job execution section.
Validate specific column details are loaded in FCC_ ER_OUTPUT table from each staging output table for the Entities after executing the job.

Cleanup Steps for Job termination

Execution of manual cleanup is required in case of any fatal user’s error. After contacting My Oracle Support, you can perform cleanup steps. For more information about cleanup steps, see the Cleanup Steps When the Load Data in FCC_ER_OUTPUT Job Terminated Manually section.

For more information about parameters, see the Parameters for Entity Resolution Job execution section.