ZhangZhihui's Blog  

当前标签:DM

DM - 如何判断来自OLTP系统的表是维度表还是事实表? ZhangZhihuiAAA 2025-12-17 15:27 阅读:13 评论:0 推荐:0   
Dimensional Modeling - Multipass SQL to Avoid Fact-to-Fact Table Joins ZhangZhihuiAAA 2025-08-18 09:56 阅读:24 评论:0 推荐:0   
Dimensional Modeling - Fact table surrogate keys ZhangZhihuiAAA 2025-08-17 14:03 阅读:8 评论:0 推荐:0   
Dimensional Modeling - Pathstring in dimensional table for variable depth hierarchies ZhangZhihuiAAA 2025-08-16 09:57 阅读:23 评论:0 推荐:0   
Dimensional Modeling - SCD Type 7: Hybrid SCD with a history table ZhangZhihuiAAA 2025-08-15 20:57 阅读:35 评论:0 推荐:0   
Dimensional Modeling - SCD Type 6: Hybrid SCD ZhangZhihuiAAA 2025-08-15 20:53 阅读:16 评论:0 推荐:0   
Dimensional Modeling: SCD Type 5: Add Mini-Dimension and Type 1 Outrigger ZhangZhihuiAAA 2025-08-15 20:45 阅读:14 评论:0 推荐:0   
Dimensional Modeling - SCD Type 4: Add Mini Dimension ZhangZhihuiAAA 2025-08-15 20:22 阅读:28 评论:0 推荐:0   
Dimensional Modeling - Enterprise Data Warehouse Bus Matrix ZhangZhihuiAAA 2025-08-15 19:56 阅读:22 评论:0 推荐:0   
Dimensional Modeling - Shrunken Rollup Dimensions ZhangZhihuiAAA 2025-08-15 19:11 阅读:29 评论:0 推荐:0   
Dimensional Modeling - Durable Surrogate Key ZhangZhihuiAAA 2025-08-15 17:15 阅读:13 评论:0 推荐:0   
Dimensional Modeling - Date Dimension Table ZhangZhihuiAAA 2025-08-15 13:57 阅读:15 评论:0 推荐:0   
Dimensional Modeling - Is it a good practice to use surrogate key in dimension tables? ZhangZhihuiAAA 2025-08-05 22:03 阅读:20 评论:0 推荐:0   
Dimensional Modeling - Table Naming Convention Policy ZhangZhihuiAAA 2025-08-05 15:42 阅读:29 评论:0 推荐:0