Develop a slowly changing dimension

[HJlassi1619437866]

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,

ill be so grateful thank you

[Prakhar1]

HI @Houssem Jlassi​ , You can use the tSCD component in your job to do this.

You can also refer this article for SCP type 2

https://dwteam.in/scd-type2-talend-open-studio/