medium10 pts · first answer countsdata-pipelinesslowly-changing-dimensionssql

Joining facts to the right SCD2 version

Facts store customer_id and order_ts, not the surrogate key. How do you join each order to the customer version valid at the time?

A.customer_id only, taking any matching rowB.customer_id, and valid_from <= order_ts < valid_toC.customer_id, and is_current = trueD.customer_id, and valid_from = order_ts

Discussion 0

Join free to post in the discussion.

Joining facts to the right SCD2 version

Discussion 0

Related questions