data reconciliation/verification TBC

1. 通过（group by字段组合）来查看这些组合（字段映射如group by A, B, C可能蕴含A=f(B,C)）的逻辑关系是否正确，同时计算每个组合的count.

eg.

 

SELECT b.USER_STAMP_NAME, a.SLR_SGMNT, COUNT(*)cnt

FROM MP_SLR_SGMNT_HST a

JOIN MP_SLR_STAMP_HST b

ON a.MONTH_BEG_DT = b.MONTH_BEG_DT ANDa.VERTICAL= b.VERTICALAND a.SLR_ID = b.SLR_ID

GROUP BY 1, 2

 

User Stamp and SLR_SGMNT有逻辑产生关系。

 

2.