ZhangZhihuiAAA - 博客园

Excel - 如何查看Excel中定义了哪些宏？

摘要： 🔎 方法 1：用 Excel 的宏列表窗口打开 Excel 文件。按 Alt + F8（或者菜单：开发工具 → 宏）。会弹出 “宏”对话框，里面会列出当前工作簿及加载的模块中所有已定义的宏名。在这里可以选择宏 → 点击编辑，跳转到 VBA 编辑器查看代码。也可以选择宏 → 点击运阅读全文

posted @ 2025-08-25 21:01 ZhangZhihuiAAA 阅读(195) 评论(0) 推荐(0)

Spark - What's the difference between the two sparksql functions: base64encrypt() and aes_encrypt()?

摘要： These two SparkSQL functions both deal with transforming data into encrypted or encoded forms, but they operate very differently and serve different p 阅读全文

posted @ 2025-08-22 15:20 ZhangZhihuiAAA 阅读(49) 评论(0) 推荐(0)

Python - Connect MySQL Database

摘要： import mysql.connector from mysql.connector import Error def create_connection(): """Create a database connection""" try: conn = mysql.connector.conne 阅读全文

posted @ 2025-08-22 11:36 ZhangZhihuiAAA 阅读(5) 评论(0) 推荐(0)

MPP SQL

摘要： 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 阅读(6) 评论(0) 推荐(0)

Dimensional Modeling - Late Arriving Facts and Late Arriving Dimensions

摘要： 🔹 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 阅读(13) 评论(0) 推荐(0)

Dimensional Modeling - Multipass SQL to Avoid Fact-to-Fact Table Joins

摘要： 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 阅读(8) 评论(0) 推荐(0)

Dimensional Modeling - Fact table surrogate keys

摘要： 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 阅读(4) 评论(0) 推荐(0)

Dimensional Modeling - Pathstring in dimensional table for variable depth hierarchies

摘要： 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) 推荐(0)

Dimensional Modeling - SCD Type 7: Hybrid SCD with a history table

摘要： 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) 推荐(0)

Dimensional Modeling - SCD Type 6: Hybrid SCD

摘要： 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) 推荐(0)

导航

2025年8月25日

2025年8月22日

2025年8月21日

2025年8月18日

2025年8月17日

2025年8月16日

2025年8月15日


博客园 © 2004-2025 浙公网安备 33010602011771号浙ICP备2021040463号-3