7.10.2 IML-HiddenRelationships-dINST

To populate the temporary tables for IML-HiddenRelationships-dINST scenario, follow these steps:

1. Execute the following refresh temporary table processes (these commands can be run in parallel).
   • If you run a scenario with the Include records for active batch parameter = '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_HIDREL_NT_JRNL TMP_HIDREL_NT_JRNL_VW
     • <OFSAAI Installed Directory>/database/db_tools/bin/refresh_temp_table.sh TMP_HIDREL_NT_WIRE TMP_HIDREL_NT_WIRE_VW
     • <OFSAAI Installed Directory>/database/db_tools/bin/refresh_temp_table.sh TMP_HIDREL_NT_ACTAXID TMP_HIDREL_NT_ACTAXID_VW
     • <OFSAAI Installed Directory>/database/db_tools/bin/refresh_temp_table.sh TMP_HIDREL_NT_ACADDR TMP_HIDREL_NT_ACADDR_VW
     • <OFSAAI Installed Directory>/database/db_tools/bin/refresh_temp_table.sh TMP_HIDREL_NT_ACPHONE TMP_HIDREL_NT_ACPHONE_VW
     • <OFSAAI Installed Directory>/database/db_tools/bin/refresh_temp_table.sh TMP_HIDREL_NT_ACEMAIL TMP_HIDREL_NT_ACEMAIL_VW
     • <OFSAAI Installed Directory>/database/db_tools/bin/refresh_temp_table.sh TMP_HIDREL_NT_ACPSWRD TMP_HIDREL_NT_ACPSWRD_VW
     • <OFSAAI Installed Directory>/database/db_tools/bin/refresh_temp_table.sh TMP_HIDREL_NT_INST TMP_HIDREL_NT_INST_VW
     • <OFSAAI Installed Directory>/database/db_tools/bin/refresh_temp_table.sh TMP_HIDREL_NT_WIREACBENE TMP_HIDREL_NT_WIREACBENE_VW
     • <OFSAAI Installed Directory>/database/db_tools/bin/refresh_temp_table.sh TMP_HIDREL_NT_WIREACORIG TMP_HIDREL_NT_WIREACORIG_VW
     • <OFSAAI Installed Directory>/database/db_tools/bin/refresh_temp_table.sh TMP_HIDREL_NT_CUACTAXID TMP_HIDREL_NT_CUACTAXID_VW
     • <OFSAAI Installed Directory>/database/db_tools/bin/refresh_temp_table.sh TMP_HIDREL_NT_CUACADDR TMP_HIDREL_NT_CUACADDR_VW
     • <OFSAAI Installed Directory>/database/db_tools/bin/refresh_temp_table.sh TMP_HIDREL_NT_CUACPHONE TMP_HIDREL_NT_CUACPHONE_VW
     • <OFSAAI Installed Directory>/database/db_tools/bin/refresh_temp_table.sh TMP_HIDREL_NT_CUACEMAIL TMP_HIDREL_NT_CUACEMAIL_VW
   • If you run 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).
     • <OFSBDF Installed Directory>/database/db_tools/bin/refresh_temp_table.sh TMP_HIDREL_NT_JRNL TMP_HIDREL_NT_JRNL_BATCH_VW
     • <OFSAAI Installed Directory>/database/db_tools/bin/refresh_temp_table.sh TMP_HIDREL_NT_WIRE TMP_HIDREL_NT_WIRE_ BATCH_VW
     • <OFSAAI Installed Directory>/database/db_tools/bin/refresh_temp_table.sh TMP_HIDREL_NT_ACTAXID TMP_HIDREL_NT_ACTAXID_ BATCH_VW
     • <OFSAAI Installed Directory>/database/db_tools/bin/refresh_temp_table.sh TMP_HIDREL_NT_ACADDR TMP_HIDREL_NT_ACADDR_ BATCH_VW
     • <OFSAAI Installed Directory>/database/db_tools/bin/refresh_temp_table.sh TMP_HIDREL_NT_ACPHONE TMP_HIDREL_NT_ACPHONE_ BATCH_VW
     • <OFSAAI Installed Directory>/database/db_tools/bin/refresh_temp_table.sh TMP_HIDREL_NT_ACEMAIL TMP_HIDREL_NT_ACEMAIL_ BATCH_VW
     • <OFSAAI Installed Directory>/database/db_tools/bin/refresh_temp_table.sh TMP_HIDREL_NT_ACPSWRD TMP_HIDREL_NT_ACPSWRD_ BATCH_VW
     • <OFSAAI Installed Directory>/database/db_tools/bin/refresh_temp_table.sh TMP_HIDREL_NT_INST TMP_HIDREL_NT_INST_ BATCH_VW
     • <OFSAAI Installed Directory>/database/db_tools/bin/refresh_temp_table.sh TMP_HIDREL_NT_WIREACBENE TMP_HIDREL_NT_WIREACBENE_ BATCH_VW
     • <OFSAAI Installed Directory>/database/db_tools/bin/refresh_temp_table.sh TMP_HIDREL_NT_WIREACORIG TMP_HIDREL_NT_WIREACORIG_ BATCH_VW
     • <OFSAAI Installed Directory>/database/db_tools/bin/refresh_temp_table.sh TMP_HIDREL_NT_CUACTAXID TMP_HIDREL_NT_CUACTAXID_ BATCH_VW
     • <OFSAAI Installed Directory>/database/db_tools/bin/refresh_temp_table.sh TMP_HIDREL_NT_CUACADDR TMP_HIDREL_NT_CUACADDR_ BATCH_VW
     • <OFSAAI Installed Directory>/database/db_tools/bin/refresh_temp_table.sh TMP_HIDREL_NT_CUACPHONE TMP_HIDREL_NT_CUACPHONE_ BATCH_VW
     • <OFSAAI Installed Directory>/database/db_tools/bin/refresh_temp_table.sh
     • <OFSBDF Installed Directory>/database/db_tools/bin/refresh_temp_table.sh TMP_HIDREL_NT_CUACEMAIL TMP_HIDREL_NT_CUACEMAIL_BATCH_ BATCH_VW
2. Execute the link analysis/network generation job. The product job template ID is 114698616.
   • If you ran a scenario where the Include records for active batch parameter = 'N' (All records loaded during lookback period will analyzed regardless name of batch process) then insert the record to KDD_PARAM_BINDING following these steps:
     1. 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', 114698653, 'false'

        )
     2. Run the Link Analysis IGN job which has a 'false' value in KDD_PARAM_BINDING
3. Execute the scenario job with appropriate value in parameter Include records for active batch . The product job template ID is 116200024.