- Subscribe to RSS Feed
- Mark Question as New
- Mark Question as Read
- Float this Question for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
Data migration: Which processor to use?
Created 06-21-2022 12:02 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
Created 06-29-2022 01:06 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
@rafy
Have you looked at the following processors:
1. GenerateTableFetch
2. QueryDatabaseTable
3. QueryDatabaseTableRecord
Thanks,
Matt
Created 06-29-2022 01:22 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
