Support Questions

Find answers, ask questions, and share your expertise

Query Oracle Database with join statement

Rising Star

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.

1 ACCEPTED SOLUTION

Super Collaborator

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.

View solution in original post

2 REPLIES 2

Super Collaborator

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.

Rising Star

Thanks.

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

👍

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