Data migration: Which processor to use?

[#1]

Hi,

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.

Thanks.

[#2]

@rafy 
Have you looked at the following processors:
1. GenerateTableFetch 
2. QueryDatabaseTable 

3. QueryDatabaseTableRecord 

Thanks,

Matt

[#3]

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.