topic Store old values in different table on update in Talend Studio

Store old values in different table on update

Anonymous — Wed, 08 Jul 2020 15:55:18 GMT

Hello, I'm a newbie in Jaspersoft ETL.

I'm trying to do an ETL process where if there is an update (on IDM_USER_V table) I would like to store the old values in a different table (that I call History). The problem is that the job is inserting all values, not only the ones being updated. How can I fix this? Below I provide a screenshot of the job.

Re: Store old values in different table on update

Prakhar1 — Thu, 09 Jul 2020 06:58:11 GMT

Hi @amiv ,

Are you updating the old values ? or you are adding a new row with updated value ?

Re: Store old values in different table on update

Prakhar1 — Thu, 09 Jul 2020 06:58:11 GMT

Hi @amiv ,

Are you updating the old values ? or you are adding a new row with updated value ?