Data Warehouse Templates for Generic CRMs - DFT
DFT Tables Views
The SQL Data Warehouse houses the DFT layer (SQL tables /views). D stands for Dimensions, F for Facts, and T for Time.
The DFT layer is the main part of the DataSelf tier 2 templates. It bridges that transforms an ERP-specific database structure into the standardized structure needed for the reports and dashboards (available in the DataSelf tier 3 and 4 templates).
Source | Table Name | |
|---|---|---|
Data Warehouse | _D_Account | |
Data Warehouse | _D_Acct_Address | |
Data Warehouse | _D_Date_Closed | |
Data Warehouse | _D_Date_Created | |
Data Warehouse | _D_Date_Expected | |
Data Warehouse | _D_Contact | |
Data Warehouse | _D_Lead | |
Data Warehouse | _D_Opportunity | |
Data Warehouse | _D_Owner | |
Data Warehouse | _D_Territory | |
Data Warehouse | _D_Ticket | |
Data Warehouse | _F_Contact_Management | |
Data Warehouse | _F_Marketing_Email | |
Data Warehouse | _F_Opportunity | |
Data Warehouse | _F_Ticket | |
Data Warehouse | _T_DataAsOf | |
Data Warehouse | _T_Date | |
Data Warehouse | _T_Period |
Key Words: single source of the truth, ETL templates, data warehouse templates, analytics templates, tds, tdsx, twb, twbx, pibx.