This section provides information about the Account Dimension loading process in the Data Foundation application.
Topics:
· About Account Dimension Table
· About SCD Process for Populating Account Dimension Table
· Deploying Account Dimension Table on Hive
· Populating Account Dimension Table
The account is where an insurer deposits premium from policies it underwrites and from which that Insurance Company funds day-to-day operations of the business.
The mapping details for the Account Dimension (DIM_ACCOUNT) tables are given here.
Map Reference Number |
Source View Name |
Logical Source View Name |
|---|---|---|
190 |
STG_BORROWINGS_V |
Stage Borrowings View |
193 |
STG_COMMITMENT_CONTRACTS_V |
Stage Commitment Contracts View |
194 |
STG_CREDIT_DERIVATIVES_V |
Stage Credit Derivatives View |
195 |
STG_FUTURES_V |
Stage Futures View |
196 |
STG_FX_CONTRACTS_V |
Stage Foreign Exchange Contracts View |
197 |
STG_GUARANTEES_V |
Stage Guarantees View |
198 |
STG_INVESTMENTS_V |
Stage Investments View |
199 |
STG_LC_CONTRACTS_V |
Stage Loan Contracts View |
201 |
STG_LOAN_CONTRACTS_V |
Stage Loan Contracts View |
202 |
STG_MM_CONTRACTS_V |
Stage Money Market Contracts View |
203 |
STG_MUTUAL_FUNDS_V |
Stage Mutual Funds View |
205 |
STG_OPTION_CONTRACTS_V |
Stage Option Contracts View |
206 |
STG_REPO_CONTRACTS_V |
Stage Repurchase Contracts View |
208 |
STG_SWAPS_CONTRACTS_V |
Stage Swaps Contracts View |
210 |
STG_TRUSTS_V |
Stage Trusts View |
262 |
STG_BORROWING_COMMITMENTS_V |
Stage Borrowing Commitments View |
263 |
STG_CORRESPONDENT_ACCOUNT_V |
Stage Correspondent Account View |
264 |
STG_TRADING_ACCOUNT_V |
Stage Trading Account View |
349 |
STG_COMMODITIES_V |
Stage Commodities View |
350 |
STG_CUSTODIAL_ACCOUNTS_V |
Stage Custodial Accounts View |
351 |
STG_MANAGED_INV_ADV_V |
Stage Managed Investment Account View |
352 |
STG_MERCHANT_BANKING_V |
Stage Merchant Banking View |
353 |
STG_PREPAID_CARDS_V |
Stage Prepaid Cards View |
354 |
STG_SPEND_OBLIGATIONS_V |
Stage Spend Obligations View |
341 |
STG_PAYMENT_SETTLEMENT_ACCT_V |
Stage Payment Settlement Account View |
400 |
STG_MERCHANT_CARDS_V |
Stage Merchant Cards View |
465 |
STG_FORWARDS_V |
Stage Forwards View |
467 |
STG_ASSETS_SOLD_V |
Stage Assets Sold View |
494 |
STG_CREDIT_PARTCPN_DETAILS_V |
Stage Credit Participation Details View |
670 |
STG_DEP_BRRWNG_PARTCPN_DTLS_V |
Stage Dep Borrowing Participation Details View |
All the above-mentioned Product Processor tables are mutually exclusive in terms of functionality. Therefore, V_ACCOUNT_NUMBER or V_CONTRACT_CODE (Primary Key of each Product Processor) must also have mutually exclusive values across all the tables. The same account number cannot be part of multiple Product Processor tables.
The SCD population in the DIM_ACCOUNT table generates individual numeric Surrogate Keys for every account number with an additional leg SKey. Below are the columns that are loaded during SCD population:
· V_ACCOUNT_NUMBER
· N_ACCT_SKEY
· N_RCV_LEG_ACCT_SKEY
· FIC_MIS_DATE
This approach replaces the function load in which the table DIM_ACCOUNT is getting loaded through the function, FN_POPDIMACCOUNT. This loads the above-mentioned columns into the DIM_ACCOUNT table. Here, the sources are the different product processor tables present in the solution, which are configured in the FSI_DIM_ACCOUNT_SETUP_DETAILS table.
Topics:
· About <INFODOM>_DIM_ACCOUNT_SCD Batch
Batch <INFODOM>_DIM_ACCOUNT_SCD is introduced with multiple tasks under it.
These tasks represent their corresponding SCD processes where different product processors are the source and DIM_ACCOUNT is the target. The MAP_REF_NUMs mentioned in the following table are introduced into the SYS_TBL_MASTER table, and subsequently into SYS_STG_JOIN_MASTER.
Depending on the requirement by an application, a task can be excluded or included from the batch execution.
All RDBMS related Account Dimension table can also be deployed on Hive (Stage and Results on Hive).
To populate data into the Account Dimension table through the SCD process, see Execute the SCD Batch of the DIM_ACCOUNT table.
NOTE:
You can also follow this SCD process to populate data into any Hive related Account Dimension table.
For supplementary information about populating data in the Dimension table, see the Supplementary Information for Dimension Loading Process section.