7.10.3 ML-NetworkOfAcEn-fAC

To populate the temporary tables for ML-NetworkOfAcEn-fAC scenario, follow these steps:

1. Execute these refresh temporary table processes (these commands can be run in parallel):
   • If you run a scenario with parameter Include records for active batch = 'N' (All records loaded during lookback period will analyzed regardless of the name of the batch process which means it will include records from other batches in a multi-country installation)
     • <OFSAAI Installed Directory>/database/db_tools/bin/refresh_temp_table.sh TMP_NETACENCU_NT_ACCTADDR TMP_NETACENCU_NT_ACCTADDR_VW
     • <OFSAAI Installed Directory>/database/db_tools/bin/refresh_temp_table.sh TMP_NETACENCU_NT_ACCTEMAIL TMP_NETACENCU_NT_ACCTEMAIL_VW
     • <OFSAAI Installed Directory>/database/db_tools/bin/refresh_temp_table.sh TMP_NETACENCU_NT_ACCTPHONE TMP_NETACENCU_NT_ACCTPHONE_VW
     • <OFSAAI Installed Directory>/database/db_tools/bin/refresh_temp_table.sh TMP_NETACENCU_NT_ACCTPSWRD TMP_NETACENCU_NT_ACCTPSWRD_VW
     • <OFSAAI Installed Directory>/database/db_tools/bin/refresh_temp_table.sh TMP_NETACENCU_NT_ACCTTAXID TMP_NETACENCU_NT_ACCTTAXID_VW
     • <OFSAAI Installed Directory>/database/db_tools/bin/refresh_temp_table.sh TMP_NETACENCU_NT_CUACADDR TMP_NETACENCU_NT_CUACADDR_VW
     • <OFSAAI Installed Directory>/database/db_tools/bin/refresh_temp_table.sh TMP_NETACENCU_NT_CUACEMAIL TMP_NETACENCU_NT_CUACEMAIL_VW
     • <OFSAAI Installed Directory>/database/db_tools/bin/refresh_temp_table.sh TMP_NETACENCU_NT_CUACPHONE TMP_NETACENCU_NT_CUACPHONE_VW
     • <OFSAAI Installed Directory>/database/db_tools/bin/refresh_temp_table.sh TMP_NETACENCU_NT_CUACTAXID TMP_NETACENCU_NT_CUACTAXID_VW
     • <OFSAAI Installed Directory>/database/db_tools/bin/refresh_temp_table.sh TMP_NETACENCU_NT_JRNL TMP_NETACENCU_NT_JRNL_VW
     • <OFSAAI Installed Directory>/database/db_tools/bin/refresh_temp_table.sh TMP_NETACENCU_NT_WIREACBENE TMP_NETACENCU_NT_WIREACBENE_VW
     • <OFSAAI Installed Directory>/database/db_tools/bin/refresh_temp_table.sh TMP_NETACENCU_NT_WIREACORIG TMP_NETACENCU_NT_WIREACORIG_VW
     • <OFSAAI Installed Directory>/database/db_tools/bin/refresh_temp_table.sh TMP_NETACENCU_NT_WIRETRXN TMP_NETACENCU_NT_WIRETRXN_VW
   • If you run a scenario with parameter Include records for active batch = 'Y' Only records loaded during the lookback period with batch name which is currently active will be analyzed[which means it will not include records from other batches in a multi-country installation)
     • <OFSAAI Installed Directory>/database/db_tools/bin/refresh_temp_table.sh TMP_NETACENCU_NT_ACCTADDR TMP_NETACEN_ACCTADDR_BATCH_VW
     • <OFSAAI Installed Directory>/database/db_tools/bin/refresh_temp_table.sh TMP_NETACENCU_NT_ACCTEMAIL TMP_NETACEN_ACCTEMAIL_BATCH_VW
     • <OFSAAI Installed Directory>/database/db_tools/bin/refresh_temp_table.sh TMP_NETACENCU_NT_ACCTPHONE TMP_NETACEN_ACCTPHONE_BATCH_VW
     • <OFSAAI Installed Directory>/database/db_tools/bin/refresh_temp_table.sh TMP_NETACENCU_NT_ACCTPSWRD TMP_NETACEN_ACCTPSWRD_BATCH_VW
     • <OFSAAI Installed Directory>/database/db_tools/bin/refresh_temp_table.sh TMP_NETACENCU_NT_ACCTTAXID TMP_NETACEN_ACCTTAXID_BATCH_VW
     • <OFSAAI Installed Directory>/database/db_tools/bin/refresh_temp_table.sh TMP_NETACENCU_NT_CUACADDR TMP_NETACEN_CUACADDR_BATCH_VW
     • <OFSAAI Installed Directory>/database/db_tools/bin/refresh_temp_table.sh TMP_NETACENCU_NT_CUACEMAIL TMP_NETACEN_CUACEMAIL_BATCH_VW
     • <OFSAAI Installed Directory>/database/db_tools/bin/refresh_temp_table.sh TMP_NETACENCU_NT_CUACPHONE TMP_NETACEN_CUACPHONE_BATCH_VW
     • <OFSAAI Installed Directory>/database/db_tools/bin/refresh_temp_table.sh TMP_NETACENCU_NT_CUACTAXID TMP_NETACEN_CUACTAXID_BATCH_VW
     • <OFSAAI Installed Directory>/database/db_tools/bin/refresh_temp_table.sh TMP_NETACENCU_NT_JRNL TMP_NETACEN_JRNL_BATCH_VW
     • <OFSAAI Installed Directory>/database/db_tools/bin/refresh_temp_table.sh TMP_NETACENCU_NT_WIREACBENE TMP_NETACEN_WIREBENE_BATCH_VW
     • <OFSAAI Installed Directory>/database/db_tools/bin/refresh_temp_table.sh TMP_NETACENCU_NT_WIREACORIG TMP_NETACEN_WIREORIG_BATCH_VW
     • <OFSAAI Installed Directory>/database/db_tools/bin/refresh_temp_table.sh TMP_NETACENCU_NT_WIRETRXN TMP_NETACEN_WIRETRXN_BATCH_VW
2. Execute the link analysis/network generation job. The product job template ID is 114698120.
   • If you run a scenario with parameter Include records for active batch = 'N'
     1. Insert a record to KDD_PARAM_BINDING using the following instructions: insert into KDD_PARAM_BINDING values ('filter_by_batch', 'Link Analysis', <param_set_id>, <true or false>) For Example:

         insert into KDD_PARAM_BINDING values ('filter_by_batch', 'Link Analysis', 118745109, 'false')

     2. Run the Link Analysis IGN job which has a 'false' value in KDD_PARAM_BINDING.
   • If you run a scenario with parameter Include records for active batch = 'Y'
     1. Insert a record to KDD_PARAM_BINDING using the following instructions: insert into KDD_PARAM_BINDING values ('filter_by_batch', 'Link Analysis', <param_set_id>, <true or false>) For Example:

         insert into KDD_PARAM_BINDING values ('filter_by_batch', 'Link Analysis', 118745110, 'true')

     2. Run the Link Analysis IGN job which has a 'true' value in KDD_PARAM_BINDING
3. Execute the scenario job. The product job template ID is 114698631.