Query Oracle Database with join statement

[#1]

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.

[#2 · Accepted solution]

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.

[#3]

Thanks.

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

👍