Hi @SK ,
Could you please share the example data in the table?
The following columns will be added to the product dimension table.
1.StartDate (DateTime) – Start date for this product to being active and related to new sales
2.Status (Boolean) – 0 means not active, 1 means active
3.Enddate (DateTime) – End date for this row to be inactive but still related to historical sales
Please refer to the following links:
Slowly Changing Dimension Transformation
Managing A Slowly Changing Dimension in SQL Server Integration Services
Best regards,
Mona
If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.