topic Re: Save date before update in Talend Studio

Save date before update

HJlassi1619437866 — Sat, 16 Nov 2024 00:02:52 GMT

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

Re: Save date before update

Anonymous — Thu, 17 Jun 2021 06:54:12 GMT

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

Regards

Shong

Re: Save date before update

Prakhar1 — Thu, 17 Jun 2021 08:38:43 GMT

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/

Re: Save date before update

HJlassi1619437866 — Thu, 17 Jun 2021 08:50:04 GMT

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

Re: Save date before update

HJlassi1619437866 — Thu, 17 Jun 2021 08:50:19 GMT

Thank you I’ll check on this