...
Listing of Data Warehouse Tables
DIM | FACT | HIST | DW |
| PPI |
|
| STG | |
|---|---|---|---|---|---|---|---|---|---|
|
|
|
|
|
|
|
|
| |
dim_date | fact_loan_disbursals |
| dw_account_action |
| dw_ppi_survey |
|
|
| |
dim_product | fact_loan_repayments |
| dw_account_charge_type currency |
| ppi_category_likelihood_bands |
|
|
| |
dim_office | fact_loan_fees_and_charges |
| dw_arrears_band_monthly fee |
| fact_ppi_survey_results |
|
|
| |
dim_personnel | dw_loan_schedules |
| dw_arrears_band_weekly fund |
|
|
|
|
| |
dim_customer |
|
| dw_mfi_currency configuration |
|
|
|
|
| |
dim_loan | fact_savings_transactions |
|
| dw_fee |
|
|
|
|
|
dim_savings |
| dw_loan_schedules_account_charge_type |
|
|
|
|
| ||
| fact_customer_fees_and_charges |
| dw_fund arrears_band_monthly |
|
|
|
|
| |
| fact_client_attendances |
| dw_mfi_configuration arrears_band_weekly |
|
|
|
|
| |
|
|
|
|
|
|
|
|
| |
|
|
|
|
|
|
|
|
| |
|
|
|
|
|
|
|
|
| |
|
|
|
|
|
|
|
|
|
DW Picture
Overview - Dimension tables surrounding fact tables
...