Save date before update

[HJlassi1619437866]

Hello talend community , hope you're doing great,

So i'm developing a job with multiple client's type, and a the type can be changed at any moment, i need to update the type and save the old one in a new table,

For exemple :

Source :

Client_1 ; Type X

Client_2 ; Type Y

Output 1 :

Client_1 ; Type X

Client_2 ; Type Y

If the type is changed like client_1 ; Type Z so :

Output 1 :

Client_1 ; Type Z

Client_2 ; Type Y

Historic_Table :

Client_1 ; Type X

I will be so grateful for you help

[Anonymous]

Hi

Can you let us know how client_1 ; Type Z comes?

Regards

Shong

[Prakhar1]

So you basically want to do SCD type 2.

this is how you can perform scd using tMap

https://www.tutorialgateway.org/talend-scd-type-2-manual/

and this is using the SCD component

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

[HJlassi1619437866]

hello thank you shog for your reply, it comes from an informix db

[HJlassi1619437866]

Thank you I’ll check on this