19.2 Prerequisites

Following is the list of tables used in the population of Fact Common Customer Summary and these tables are required to be loaded prior to running the T2T:

• DIM_CUSTOMER
• DIM_BANDS
• DIM_EDUCATION
• DIM_CUSTOMER_TYPE
• DIM_GENDER
• DIM_INDUSTRY
• DIM_CHANNEL
• DIM_GEOGRAPHY
• DIM_MARITAL_STATUS
• DIM_MANAGEMENT
• DIM_PROFESSION
• DIM_CREDIT_RATING
• DIM_VINTAGE
• DIM_MIGRATION_REASONS
• FCT_COMMON_ACCOUNT_SUMMARY
• FCT_LIMITS_SUMMARY
• STG_CUSTOMER_DETAILS
• STG_PARTY_RATING_DETAILS
• STG_PARTY_FINANCIALS

Dimensions tables are loaded through the SCD process. The fact tables FCT_COMMON_ACCOUNT_SUMMAY is loaded from the respective T2T processes.