question Re: Query Oracle Database with join statement in Support Questions

Query Oracle Database with join statement

rafy — Tue, 21 Apr 2026 07:54:07 GMT

Hi,

Please, I have a very large data to fetch incrementally( i need to store state) from an Oracle Database.

And my query contains multiple JOIN statements.

Please, what is the best processor to use for this scenerio because from the information i gathered i was told QueryDatabaseTableRecord proc cannot handle JOIN statements.

Thanks.

Re: Query Oracle Database with join statement

SAMSAL — Tue, 28 Jun 2022 13:28:22 GMT

Hi,

Have you tried GenerateTableFetch processor. It can do incremental by saving maximum value for given column\s. Regarding the join why dont you create a view that does all the needed join and use that as an input for the GenerateTableFetch processor Table Name property.

Re: Query Oracle Database with join statement

rafy — Tue, 28 Jun 2022 13:47:00 GMT

Thanks.

I think your approach is better to push all overheads to the Oracle Db rather than NIFI.

👍