K.7 <INFODOM>_DIMENSION_ACCOUNTS

This seeded batch contains the following SCDs to populate the dim_accounts table:

• STG_ANNUITY_CONTRACTS
• STG_BILLS_CONTRACTS
• STG_BORROWINGS
• STG_CARDS
• STG_CASA
• STG_COMMITMENT_CONTRACTS
• STG_FUTURES
• STG_FX_CONTRACTS
• STG_GUARANTEES
• STG_INVESTMENTS
• STG_LC_CONTRACTS
• STG_LEASES_CONTRACTS
• STG_LOAN_CONTRACTS
• STG_MM_CONTRACTS
• STG_MUTUAL_FUNDS
• STG_OD_ACCOUNTS
• STG_OPTION_CONTRACTS
• STG_REPO_CONTRACTS
• STG_RETIREMENT_ACCOUNTS
• STG_TD_CONTRACTS
• STG_TRUSTS
• STG_MERCHANT_CARDS
• STG_CREDIT_DERIVATIVES

Note:

The DIMENSION_ACCOUNTS seeded batch is common across all the EPM applications and hence the STG_CREDIT_DERIVATIVES SCD is part of the seeded batches.

However, this task does not apply to OFS PFT because this staging table is not available in the PFT Data Model.