Can SQLExecutor be used to get around having to read in all the data from a database table into FME and then running a feature joiner?
Consider the example below we need to read in the entire table of 2Million plus records to extract data we are interested in.
What I think should be possible but I'm not sure how to implement it is to create a temp table and use that as a subselect or joined table to get the data using a SQL query
Best answer by elpone
View original