topic Re: Compare changes in a datasource after a certain time in Talend Studio

Compare changes in a datasource after a certain time

pawe84 — Tue, 11 Jun 2019 15:11:02 GMT

How I can compare changes in my datasource after a certain while?

Let's say there is a table with 3 columns like in this small example.

At time=t0 we have this result:

After a while at time=t1 some values have changed (in this case amount and price).

I think I need a temporry table where I can store a status or sth like that.

But which components do I have to use to compare the changes?

In the output I only need the rows which were changed.

Thanks for any advice.

Re: Compare changes in a datasource after a certain time

fdenis — Tue, 11 Jun 2019 15:35:14 GMT

did you have a key?
can you set trigger to log changes?
what is compare changes for you?
do you want to store data?
did you have update time?
there is a lot of questions…..

Re: Compare changes in a datasource after a certain time

Anonymous — Tue, 11 Jun 2019 18:12:46 GMT

Hi,

You might be interested in CDC. Please refer the link below.

https://help.talend.com/reader/6lpaT_M~MEVrltFQcrPe4g/ok6_wxMohOla6ba34VHcew

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂