13.1 Overview of Account Dimension

The SCD population in DIM_ACCOUNT table generates individual numeric Surrogate Keys for every account number with an additional leg skey. Below are the columns that will be loaded during SCD population:

• V_ACCOUNT_NUMBER
• N_ACCT_SKEY
• N_RCV_LEG_ACCT_SKEY
• FIC_MIS_DATE
• V_PRODUCT_PROCESSOR_NAME
• V_ORIGINAL_ACCOUNT_NUMBER
• F_LATEST_RECORD_INDICATOR
• V_APPLN_NUMBER
• V_CCY_CODE