27 Mitigants Results Tables

This section provides information about Mitigants Results Tables in the Oracle Insurance Data Foundation application and step-by-step instructions to use this section.

Topics:

· About Mitigants Results T2Ts (Result Tables)

· Deploying Mitigants Results Tables on Hive

· Populating Mitigants Results T2T Result Tables

· Related Topics

Mitigant means to reduce the loss of life and property by reducing the impact of undesirable events.

The purpose of the Mitigants Results table is to store the list of actions to be taken to reduce the impact of undesirable events.

About Mitigants Results T2Ts (Result Tables)

Mitigants Results T2Ts and their description are given here.

Table 247: Mitigants Results T2Ts and their description

T2T Name	T2T Description
T2T_FCT_MITIGANTS	This T2T stores consolidated data of all Mitigants and their details.
T2T_FCT_ACCOUNT_MITIGANT_MAP	This T2T stores account for Mitigant mapping details. This T2T stores more than one Mitigant to be mapped to an account.

The mapping details for the Mitigants Results T2Ts are given here.

Table 248: The mapping details for the Mitigants Results T2Ts

Source Table Name	Logical Stage Table Name	Fact Table Name	Logical Fact Table Name	T2T Name
STG_MITIGANTS	Stage Mitigants	FCT_MITIGANTS	Fact Mitigants	T2T_FCT_MITIGANTS
STG_ACCOUNT_MITIGANT_MAP	Stage Account Mitigant Map	FCT_ACCOUNT_MITIGANT_MAP	Fact Account Mitigant Map	T2T_FCT_ACCOUNT_MITIGANT_MAP

Deploying Mitigants Results Tables on Hive

All RDBMS related Result tables can also be deployed on Hive (Stage and Results). Deploy the Hive T2Ts using the Rules Run Framework. For more information, see the Rules Run Framework section in the Oracle Financial Services Advanced Analytical Applications Infrastructure User Guide Release 8.1.0.0.0.

NOTE	In general, Stage and Result tables are also supported in Hive. However, there are some exceptions. For a list of tables that are not supported in Hive, see List of Unsupported T2Ts

Populating Mitigants Results T2T Result Tables

Follow this T2T process to populate data into any T2T Result table:

NOTE	Only RDBMS T2Ts can be executed using the PMF.

1. To populate data into any T2T Result table, execute the PMF process for that T2T. For a detailed procedure, see the following sections:

a. Prerequisites for loading T2T.

b. Select the Run Parameters and Execute the Run.

2. To check the T2T execution status and verify the log files of any Result table, follow the procedure in the Verify the Run Execution section.

3. To check the error messages, if any, follow the procedure in the Check Error Messages section.