span8
span4
span8
span4
I have loaded 100 address (city, state, street, zip) from a file and I need to validate if each address already exists in the database or must be added.
How can I perform this operation in FME taking care about performance?
Thanks so much for any help !
It can often be quicker to create a temporary table in the database with 100 addresses followed by an sqlexecutor to run a single query to evaluate which of the 100 do not exist in the database
@ediaze, given you don't want to read in all the address master records, I'd take a look at something like the Joiner transformer, that will read however many features from the address master match based on the join you specify and your 100 features will be output via the joined (matched) or unjoined (unmatched) ports.
Alternatively, you could also try a SQLExecutor transformer to run some SQL against the address master database, running the sql statement once for each record, i.e.100 times, so not too much of an impact, but I'd probably try the Joiner route above first
DatabaseJoiner doesn't find PostgreSQL record inserted by SQLExecutor on previous feature6 Answers
oracle_orientation from SqlExecutor0 Answers
SQLExecutor with Exec - how to use the return value?4 Answers
How to assign values from SQL Server Sequence to ESRI Feature Class Record1 Answer
Joining multiple CSV files2 Answers
© 2020 Safe Software Inc |Legal