Skip to content

financial

sqllocks_spindle.domains.financial

Financial services domain — banking, accounts, transactions, and loans.

Classes

FinancialDomain

Bases: Domain

Banking and financial services domain.

Available schema modes
  • 3nf: Normalized schema with proper 3NF relationships

Tables (3NF mode): - branch: Bank branches with locations - customer: Bank customers with credit tiers - account: Checking, savings, investment accounts - transaction: Deposits, withdrawals, transfers, payments - transaction_category: Category hierarchy - loan: Mortgages, auto, personal, student loans - loan_payment: Monthly loan payments - card: Credit/debit cards linked to accounts - fraud_flag: Suspicious transaction flags - statement: Monthly account statements

Methods:
star_schema_map()

Return the star schema mapping for the Financial domain.

Produces
  • dim_customer (from customer)
  • dim_branch (from branch)
  • dim_account (from account)
  • dim_category (from transaction_category)
  • fact_transaction (from transaction)
  • fact_loan_payment (from loan_payment + loan)
cdm_map()

Return the CDM entity map for the Financial domain.

Maps source table names to Microsoft Common Data Model entity names.