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

Selecting current rows from SCD2

An SCD Type 2 customer table has valid_from, valid_to and is_current. Which filter returns each customer's current row?

A.WHERE valid_from = CURRENT_DATEB.WHERE valid_to < CURRENT_DATEC.WHERE is_current = trueD.WHERE customer_sk = MAX(customer_sk)

Discussion 0

Join free to post in the discussion.