This section provides information about Product tables in the Oracle Insurance Data Foundation application.
Topics:
· About Product Dimension Table
· Deploying Product Tables on Hive
· Populating Product Dimension Tables
Product tables are used to load the product details that the customer has opted for.
Product Dimension table names and their description are given here.
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. |
The mapping details for the Product Dimension tables are given here.
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 |
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.
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.1.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
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.
You can see the following topics related to other function-specific tables: