17 Product Tables

This section provides information about Product tables in the Oracle Insurance Data Foundation application.

Topics:

· About Product Dimension Table

· About Product T2T (Result Table)

· Deploying Product Tables on Hive

· Populating Product Dimension Tables

· Populating Product Related T2T (Result Table)

· Related Topics

Product tables are used to load the product details that the customer has opted.

About Product Dimension Tables

Product Dimension table names and their description are given here.

Table 73: Product Dimension table names and their description
Logical Dimension Table Name	Dimension Table Description
Product Dimension	This table stores the details of all the products (existing and stopped) offered by the Insurance Company.
Product Category Dimension	This table stores details about the loan product category.
Product Type Dimension	This table stores details about loan product type.
Product Feature Dimension	This table stores the product feature details.
Surrender Charge Schedule Master Dimension	This table stores the codes and descriptions of different surrender charge schedules.

The mapping details for the Product Dimension tables are given here.

Table 74: The mapping details for the Product Dimension tables
Map Reference Number	Source Table Name	Logical Stage Table Name	Dimension Table Name	Logical Dimension Table Name
78	STG_PRODUCT_MASTER	Stage Product Master	DIM_PRODUCT	Product Dimension
83	STG_PRODUCT_CATEGORY_MASTER	Stage Product Category Master	DIM_PRODUCT_CATEGORY	Product Category Dimension
85	STG_PRODUCT_TYPE_MASTER	Stage Product Type Master	DIM_PRODUCT_TYPE	Product Type Dimension
128	DIM_PRODUCT_V	Product Dimension View	DIM_PRODUCT	Product Dimension
151	STG_PRODUCT_FEATURE_MASTER	Stage Product Feature Master	DIM_PRODUCT_FEATURE	Product Feature Dimension
1008	STG_SURR_CHARGE_SCH_MASTER	Stage Surrender Charge Schedule Master	DIM_SURR_CHARGE_SCH_MASTER	Surrender Charge Schedule Master Dimension

About Product T2T (Result Table)

Product T2T and its description is given here.

Table 77: Product T2T and its description
T2T Name	T2T Description
T2T_FCT_SURRENDER_CHARGE_SCHEDULE	This T2T stores the surrender charge schedule for a combination of different Policy Begin Year and Policy End Year Values. The surrender charge schedule can be different for each product and they change based on the market trends and regulatory changes. This T2T supports surrender charges applicable for different insurance products. For example, in Life Insurance Contract or Annuity Contract, based on the policy age, surrender charges are applied.

The mapping details for the Product T2T is given here.

Table 78: The mapping details for the Product T2T
Source Table Name	Logical Stage Table Name	Fact Table Name	Logical Fact Table Name	T2T Name
STG_SURRENDER_CHARGE_SCHEDULE	Stage Surrender Charge Schedule	FCT_SURRENDER_CHARGE_SCHEDULE	Fact Surrender Charge Schedule	T2T_FCT_SURRENDER_CHARGE_SCHEDULE

NOTE:

The FSI_PROD_STD_PROD_TYPE_MAP table has been added for mapping purposes if the customer so desires. This table stores Product Standard Product Type mapping details.

Deploying Product 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.2.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 Product Dimension Tables

Follow this SCD process to populate data into a Dimension table:

NOTE:

You can also follow this SCD process to populate data into any Hive-related Dimension table.

1. To populate data into a Dimension table, execute the SCD batch. For a detailed procedure, see the Slowly Changing Dimension (SCD) Process.

2. To check the SCD batch execution status of a Dimension table, follow the procedure Check the Execution Status of the SCD Batch.

3. To verify log files, and check the error messages (if any), follow the procedure Verify Log Files and Check Error Messages.

Populating Product Related T2T (Result Table)

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.