![]() Our data warehouse application consists of three master data tables, including: 1) MasterCust for customer master 2) MasterProdHier for Product IDs and other dimensions pertaining to Products/Parts and 3) MasterReps as the Sales Rep Master. The Calendar table was described in our earlier post that explained how to build an accounting calendar, which you may want to review if you have not already done so. We will describe each table in more detail in a moment. The list of tables in our Access database is displayed below. We describe specifics for designing master data and transaction tables for a data warehouse, that support a midsize business data analytics needs.Ĭlick to Tweet Access Tables Used in Our Data Warehouse ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |