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?
Solved
Select Distinct values Oracle Reader
+30- Influencer
Best answer by david_r
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.
- Best Answer
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.
+30- Influencer
david_r wrote:
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
Rich Text Editor, editor1
Editor toolbars
Press ALT 0 for help
Helpful Members This Week
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.