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.