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
+31- 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.
This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
- 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.
+31- Influencer
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.