SELECT o.order_id, c.customer_sk
FROM fact_order o
JOIN dim_customer c
  ON o.customer_id = c.customer_id
 AND o.dt >= c.start_date AND o.dt < c.end_date;