7.2 Creating Result Tables

To create Result Tables for HIVE, follow these steps:

  1. Login to the server where OFSAA is installed.
  2. Navigate to the path $FIC_HOME/realtime_processing/infodomscripts/DDL/hive and execute the scripts in create_infodom.hql file into the Datadom (HIVE schema).
  3. The tables RTI_ASSMNT_EVAL_RESULT and RTI_ASSMNT_RESULT are created.