SEL begin_date, COUNT(1)
FROM
(
SEL
user_id
, begin_date
, end_date
, MAX(begin_date) OVER (PARTITION BY user_id ORDER BY begin_date, end_date ROWS BETWEEN 1 FOLLOWING AND 1 FOLLOWING) AS next_begin_date
FROM SLOWLY_CHANGING_DIMENSION
) t
WHERE t.next_begin_date IS NOT NULL AND t.next_begin_date <= t.end_date
GROUP BY 1
ORDERY BY 1
;
CHECK DQ Issue in Slowly Changing Dimension
最新推荐文章于 2010-10-29 17:20:00 发布