SCD best practice · Learn Microsoft Fabric

SCD best practice

Hi,

I have a SCD table named targets and the following columns id, product, target, version, startdate and enddate. Currently, i look-up my sales data by doing a inner join to targets table and linked like this sales.sales_date between target.startdate and target.enddate. I feel that this is not optimal due to size of SCD(around 150k rows per version and changes 3 to 5 times per week). what is the best approach to achieve optimal performance?

2 comments