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.
Tag as "solved" for others! Kudos to thanks!
You might be interested in CDC. Please refer the link below.
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 :-)
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Watch the recorded webinar!
Learn how to do cool things with Context Variables
Find out how to migrate from one database to another using the Dynamic schema
Pick up some tips and tricks with Context Variables