Support Questions
Find answers, ask questions, and share your expertise

Data migration: Which processor to use?

Rising Star

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 REPLIES 2

Master Guru

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

3. QueryDatabaseTableRecord 

Thanks,

Matt

Rising Star

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. 

Take a Tour of the Community
Don't have an account?
Your experience may be limited. Sign in to explore more.