| 主维 | 注册信息 + 当前等级 |
|---|---|
| 迷你维 | 等级 x 消费力组合 |
| 标签 | 独立标签表按需关联 |
客户主维示意
客户主维示意
CREATE TABLE dim_customer (
customer_sk bigint,
customer_id string,
name string,
reg_channel string,
tier string,
cur_profile_sk bigint
) STORED AS ORC;多源客户先做实体合并再入主维，合并规则（身份证/手机号优先级）要登记。