摘要：
MPP SQL refers to SQL used in a Massively Parallel Processing (MPP) database system. Let’s break it down carefully: 1. Massively Parallel Processing (
阅读全文
posted @ 2025-08-21 21:48
ZhangZhihuiAAA
阅读(10)
推荐(0)
摘要：
🔹 1. Late Arriving Facts (a.k.a. Early Arriving Facts) The fact record itself (transaction, order line, etc.) comes in earlier than some of its requi
阅读全文
posted @ 2025-08-18 11:35
ZhangZhihuiAAA
阅读(17)
推荐(0)
摘要：
1. The Problem: Fact-to-Fact Joins In a data warehouse, fact tables are very large (millions/billions of rows). Sometimes analysts want to combine two
阅读全文
posted @ 2025-08-18 09:56
ZhangZhihuiAAA
阅读(22)
推荐(0)
摘要：
Fact table surrogate keys are often misunderstood. Let’s break it down clearly. 1. Fact Tables and Keys A fact table contains measures (quantitative d
阅读全文
posted @ 2025-08-17 14:03
ZhangZhihuiAAA
阅读(8)
推荐(0)
摘要：
When you have a variable depth hierarchy (the number of levels is not fixed), using a pathstring column in the dimension table is a practical and effi
阅读全文
posted @ 2025-08-16 09:57
ZhangZhihuiAAA
阅读(19)
推荐(0)
摘要：
SCD Type 7 is a less common and more advanced type of Slowly Changing Dimension (SCD). It is essentially a hybrid SCD approach designed to combine Typ
阅读全文
posted @ 2025-08-15 20:57
ZhangZhihuiAAA
阅读(30)
推荐(0)
摘要：
SCD Type 6 is another type of Slowly Changing Dimension (SCD) that combines Type 1, Type 2, and Type 3 strategies to provide both historical tracking
阅读全文
posted @ 2025-08-15 20:53
ZhangZhihuiAAA
阅读(13)
推荐(0)
摘要：
SCD Type 5 is one of the Slowly Changing Dimension (SCD) techniques used in data warehousing to track historical changes in dimension attributes, espe
阅读全文
posted @ 2025-08-15 20:45
ZhangZhihuiAAA
阅读(10)
推荐(0)
摘要：
A mini dimension is a concept in data warehousing used to handle certain types of rapidly changing or high-cardinality dimension attributes in a more
阅读全文
posted @ 2025-08-15 20:22
ZhangZhihuiAAA
阅读(19)
推荐(0)
摘要：
An Enterprise Data Warehouse (EDW) Bus Matrix is a core planning tool in Kimball’s dimensional modeling methodology that maps business processes to di
阅读全文
posted @ 2025-08-15 19:56
ZhangZhihuiAAA
阅读(14)
推荐(0)
浙公网安备 33010602011771号
浙ICP备2021040463号-3
