6.16 Configuring Link Analysis

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) <OFSBDF Installed Directory>/database/db_tools/bin/refresh_- temp_table.sh TMP_HIDREL_NT_JRNL TMP_HIDREL_NT_JRNL_VW …

     <OFSBDF Installed Directory>/database/db_tools/bin/refresh_temp_table.sh TMP_HIDREL_NT_CUACEMAIL TMP_HIDREL_NT_CUACEMAIL_VW

   • If you run a scenario with the Include records for active batch parameter = 'Y' (Records loaded during lookback period with the batch name which is active will be analyzed).

     <OFSBDF Installed Directory>/database/db_tools/bin/refresh_temp_table.sh TMP_HIDREL_NT_JRNL TMP_HIDREL_NT_JRNL_BATCH_VW …

     <OFSBDF Installed Directory>/database/db_tools/bin/refresh_temp_table.sh TMP_HIDREL_NT_CUACEMAIL TMP_HIDREL_NT_CUACEMAIL_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 follow these steps:

     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')

     Run the Link Analysis IGN job which has a 'false' value in KDD_PARAM_BINDING

   • If you ran a scenario where the Include records for active batch parameter = 'Y' (Records loaded during the lookback period with batch name which is active now will be analyzed), follow these steps:

     Insert the record to KDD_PARAM_BINDING using the following instruction:

     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', 114698654, 'true')
     Run the Link Analysis IGN job which has a 'true' value in KDD_PARAM_BINDING
     

3. Execute the link analysis/network generation job. The product job template ID is 114698616.

   Execute the scenario job with the appropriate value in the Include records for active batch parameter. The product job template ID is 116200024.