Re: Incremental Fetch in NIFI

2021-02-24 Thread Matt Burgess
Khaja, There are two options in NiFi for incremental database fetch: QueryDatabaseTable and GenerateTableFetch. The former is more often used on a standalone NiFi cluster for single tables (as it does not accept an incoming connection). It generates the SQL needed to do incremental fetching

Incremental Fetch in NIFI

2021-02-24 Thread KhajaAsmath Mohammed
Hi, I have a use case where I need to do incremental fetch on the oracle tables. Is there a easy way to do this? I saw some posts about querydatabase table. want to check if there is any efficient way to do this? Thanks, Khaja