4.3 Prerequisites when MATCHING_MECHANISM is Set to Oracle Text (OT)

Before executing the ER jobs when matching mechanism is selected as “OT”, follow these steps:

1. Enable the required rulesets.
2. Navigate to <COMPLIANCE_STUDIO_INSTALLATION_PATH>/deployed/candidateselection/ utility/bin directory.
3. Initialize the ER schema by executing the following command:
   ./CreateMViewAndIndex.sh <DATA_SCHEMA_ALIAS> <PIPELINE_ID>
   For example: ./CreateMViewAndIndex.sh ER_SCHEMA_ALIAS CSA_8129
4. Execute the following command:
   ./CreateDBThesaurus.sh <DATA_SCHEMA_ALIAS> <PATH TO STORE PRE-PROCESSED FILES GENERATED BY UTILITY> <MODE>
   For example: ./CreateDBThesaurus.sh ER_SCHEMA_ALIAS /user/thesaurusFiles CREATE
   The script has two options:

   • Create: This option helps to generate the pre-seeded thesaurus in the database.
   • Reset: This option helps the user to update the pre-existing thesaurus. If there is any change in the data, the user can run the script with a reset flag, and the thesaurus will be updated.

   Note:

   Only one thesaurus can be created in one Database server with the specified thesaurus name.