Skip to main content
rafy
rafy
Gold ⭐️
June 28, 2022
Solved

Query Oracle Database with join statement

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.

SAMSAL
SAMSALAnswer
Platinum ⭐️⭐️⭐️
June 28, 2022

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 in thread

2 replies

SAMSAL
SAMSALAnswer
Platinum ⭐️⭐️⭐️
June 28, 2022

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.

Translate
    rafy
    rafyAuthor
    Gold ⭐️
    June 28, 2022

    Thanks.

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

    👍

    Translate
    Terms & ConditionsAccessibility statement