| 层级内 | DWD 明细与 DWS 汇总口径一致 |
|---|---|
| 跨表 | 主表金额与明细金额合计一致 |
| 跨系统 | 数仓与业务库或账单核对 |
| 处置 | 差异定位到具体单据并解释原因 |
主表与明细金额核对
主表与明细金额核对
SELECT o.order_id, o.pay_amount, SUM(d.item_amount) AS detail_sum
FROM dwd_trade_order_di o
JOIN dwd_trade_order_detail_di d ON o.order_id = d.order_id
WHERE o.dt = '2026-10-11' AND d.dt = '2026-10-11'
GROUP BY o.order_id, o.pay_amount
HAVING ABS(o.pay_amount - SUM(d.item_amount)) > 0.01
LIMIT 50;一致性检查的容差要按业务定义：金额可用 0.01 元容差，计数类通常要求完全相等。