Using Slowly Changing Dimension
Since client source data is not provided with correct end time period for SCD, I am trying to use start date as time interval and convert the scd table to view price listed for each date on separate line. Please check below scd table (note that product_id and start_date are PK):
The output of the view would be following:
Appreciate any feedback.