5.6.4 Populating Accounts Dimension

Account Number is an alphanumeric unique identifier within each staging instrument tables. ID_NUMBER is a numeric unique identifier within processing instrument tables. Hence, there is a need to generate a numeric surrogate key for each of the account number. This information is stored in DIM_ACCOUNT table.

You can populate DIM ACCOUNT table using SCD. For more information on Slowly Changing Dimension (SCD) to populate into DIM ACCOUNT, see Document ID 1273210.1 (How to Populate the DIM_ACCOUNT Table in OFSAA).