7.3.3 Fact Based Dimension Loader

The "Populating Missing Master Data from Factual Data" feature allows you to extract distinct values of the specified business term from the factual data which are missing in the Dimension table and load them into Stage Master tables. This helps to ensure that the references are accurate in the Fact Results.

This feature allows populating the stage dimension table from Stage Fact tables in case the source for dimension table did not provide the references.

1. Share the configuration as an excel file with the details such as Dimension Name, Stage Fact Table Name and Stage Fact Column Name to the support team. SOP will be prepared based on this and the configuration table will be set. The sample is as follows:

   Table 7-8 Configuration

   Dimension Name	Stage Fact Table Name	Stage Fact Column Name
   Account	Casa	Account or Contract Number
   Account	Credit Derivatives	Account or Contract Number
   Accounting Standard	Commodity Contracts	Accounting Standard Code

2. After loading the Stage Fact tables, navigate to the PMF Widget Missing Master Loader and trigger it. Before triggering the widget, the data between the Stage Master and the Dimension must be synchronized by running the SCD.
3. For the input As of Date, this feature will extract distinct values of the specified Business Term (column) from the factual data which are missing in the Dimension table and load them into the Stage Master tables.

   Note:

   Only As of Date runtime parameter is considered by the Missing Master Loader.
4. The numeric identifier field for the newly remediated data will be a 14 digit unique number and for the existing but inactive records of the dimension, it will be the existing numeric identifier. The Data Source will be set as ‘SYSTEM’.
   The non-nullable columns will be set with default values as below:

   • Varchar- 'MSG' or Space (If the length of the column is less than 3 characters)
   • Numeric- 0
   • Flag- 'N'
   • Date- As of Date provided by the user
5. Run the SCDs for the remediated Master tables and load the dimensions.

   Note:

   • In case some data is pending to be loaded to Dimension, then the SCD needs to be executed before the execution of Missing Master Loader.
   • Each execution of Missing Master Loader should be followed by an SCD execution of all the dimensions that are remediated.
   • This feature is expected to be used for only remediation of missing records and must not be primarily used for Stage Master load.