I want to migrate data from a remote db tables to a destination folder.
What processor is optimal for processing a table whose records get updated.
@rafy Have you looked at the following processors:1. GenerateTableFetch 2. QueryDatabaseTable
3. QueryDatabaseTableRecord Thanks,
Thank you Sir for the reply.
Yes i have looked into them.
The issue i have is that my query statement has multiple join conditions. And also the table is incremental.
So, someone proposed i should convert the query to a database table view, then i can now supply the view name to any of the processors you mentioned above.
Please, do you have a better approach.
Thank you sir.