Hello everyone, i have a use case where i have clients with :
Pk | code | name | salary | type | start_date | end_date
1 1 A 1000 X 1/1/2020 12/1/2020
i need to add a row to my output when the salary ( due to specific condition ) change the type must change and add new row with the new type and the code should stay the same with a new date
i feel like it’s going to be a slowly changing dimension, and as a beginner i need your help guys to develop a job that align with my need,
