摘要：
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
阅读(14)
推荐(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
阅读(27)
推荐(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
阅读(11)
推荐(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
阅读(6)
推荐(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
阅读(9)
推荐(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
阅读(9)
推荐(0)
摘要：
Shrunken Rollup Dimensions are a concept from Kimball-style dimensional modeling where you create a smaller, summarized version of an existing dimensi
阅读全文
posted @ 2025-08-15 19:11
ZhangZhihuiAAA
阅读(14)
推荐(0)
摘要：
In dimensional modeling, a durable surrogate key (DSK) is: Definition A durable surrogate key is a surrogate key value in a dimension table that never
阅读全文
posted @ 2025-08-15 17:14
ZhangZhihuiAAA
阅读(6)
推荐(0)
摘要：
PostgreSQL: Generate Date Dimension -- 1. Create table CREATE TABLE date_dim ( date_key INT PRIMARY KEY, -- e.g., 20250815 date_actual DATE NOT NULL,
阅读全文
posted @ 2025-08-15 13:57
ZhangZhihuiAAA
阅读(10)
推荐(0)
摘要：
在 Hive SQL 里，UDTF 是 User-Defined Table-Generating Function 的缩写，也叫 用户自定义表生成函数。 作用： 普通的 UDF（User-Defined Function）是一行进一行出的（1→1），UDAF（User-Defined Aggreg
阅读全文
posted @ 2025-08-13 09:00
ZhangZhihuiAAA
阅读(29)
推荐(0)
浙公网安备 33010602011771号
浙ICP备2021040463号-3
