Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Listing of Data Warehouse Tables

DIM

 

FACT

 

HIST

 

DW

 

 

PPI

 

 

STG

 

 

 

 

 

 

 

 

 

 

 

 

 

dim_date

 

fact_loan_disbursals

 

hist_loan_balances

 

dw_account_action

 

 

dw_ppi_survey

 

 

stg_personnel_names_and_name_changes

dim_product

 

fact_loan_repayments

 

hist_loan_arrears

 

dw_currency

 

 

ppi_category_likelihood_bands

 

 

stg_customer_and_account_updates

dim_office

 

fact_loan_fees_and_charges

 

hist_savings_balances

 

dw_fee

 

 

fact_ppi_survey_results

 

 

stg_customer_type1_columns

dim_personnel

 

dw_loan_schedules

 

 

 

dw_fund

 

 

 

 

 

stg_loan_type1_columns

dim_customer

 

 

 

 

 

dw_mfi_configuration

 

 

 

 

 

 

dim_loan

 

fact_savings_transactions

 

 

 

 

 

 

 

 

 

stg_etl_run_history

dim_savings

 

 

 

 

 

dw_account_charge_type

 

 

 

 

 

 

 

 

fact_customer_fees_and_charges

 

 

 

dw_arrears_band_monthly

 

 

 

 

 

 

 

 

fact_client_attendances

 

 

 

dw_arrears_band_weekly

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

...