I have an Oracle database with about 500,000 entries. I want to read in 1 feature for each unique value of 'DEVICE_TYPE'. Is there a select or where clause I can use to do this?
Page 1 / 1
The most efficient will be to use an SQLExecutor rather than a reader for this, e.g.
SELECT DISTINCT DEVICE_TYPE
FROM my_table_nameIf you want it to be as fast as possible, make sure that "DEVICE_TYPE" is indexed in the database.
For larger datasets, this will be an order of magnitude faster than reading all the data into FME and then using the DuplicateRemover.
The most efficient will be to use an SQLExecutor rather than a reader for this, e.g.
SELECT DISTINCT DEVICE_TYPE
FROM my_table_nameIf you want it to be as fast as possible, make sure that "DEVICE_TYPE" is indexed in the database.
For larger datasets, this will be an order of magnitude faster than reading all the data into FME and then using the DuplicateRemover.
Thanks @david_r, this was very helpful.
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.