| 结构 | 主实体键 + 关联键 + 权重 |
|---|---|
| 用途 | 多对多分摊 |
| 注意 | 权重合计要可控 |
示例
示例
-- bridge_order_promo(order_key, promo_key, weight)
SELECT p.name, sum(f.amount * b.weight) FROM fact_order f JOIN bridge_order_promo b ON f.order_key=b.order_key JOIN dim_promo p ON b.promo_key=p.promo_key GROUP BY 1;多值分摊会带来重复计数风险，报表口径要显式说明。