Is there a way to capture any column changes from a source table in an oracle database to another same table in different oracle database (Don't have enterprise so can't do CDC).
Data changes can be captured though wanted to check if there is way to even capture column changes (Column definition change, New Column addition) using open studio.
Thanks in advance!
If you want to capture the changed data and only load these changed data into target table to achieve table sync, you can compare tables by using tMap.
The work flow should be: Target DB-->tMap(make inner join on your input and set the "Catch lookup inner join reject" as true)-->output
The output will be the changed data.
Thanks Sabrina.. Data change I understand can be captured using inner join rejects. I was more interested in capturing any column/column properties changes. Like if any column addition in source or changing the properties of column from varchar to number in source.(Oracle is the db)
So far, with talend CDC Trigger mode, data extraction takes place at the same time the Insert, Update, or Delete operations occur in the source tables, and the change data is stored inside the database in change tables. The changed data, thus captured, is then made available to the target system(s) in a controlled manner, using subscriber views.
There is no capturing any column/column properties changes operation.