Member since
09-06-2022
2
Posts
0
Kudos Received
0
Solutions
09-08-2022
04:08 AM
Thanks for your reply, I checked CDC processor but it is specific to MySQL db. My source db is Oracle. ID is not the incremental column in the tables. There is a modifiedtime column in both table_a and table_b that shows the updated time of the row. For now I used modifiedtime column in table_a as Maximum-value Columns in QueryDatabase processor, but when modifiedtime column updated on table_b (eg. column_1 table value updated in table_b) I can't track the change in this table. Should I use another QueryDatabase processor and set modifiedtime column in table_b as Maximum-value Columns?
... View more