When I use any SQL reader if I limit the attribute in the "User Attribute" tab with the option "Exposed Attributes": FME seems (regarding perf) to use a query like "Select Attrib1, Attrib2 from..." in place of a "Select * from ..." when I use Feature Reader It fetch all column even if I output to generic port and expose only some attribute. I have some Huge binary and text collumn that I dont need and I fetch thru a slow connection. Any Idea ?
Solved
Is there a way to make a partial fetch (only some column) with featureReader like with other (Legacy)Reader
Best answer by markatsafe
@deneb Unfortunately it is not possible to select which attributes you can read in FeatureReader, as you can with the 'native' reader. FeatureReader does not yet expose all the parameters and functionality if each Feature Type. Please add your voice to this Idea, along with any comments on why this is important to your workflow. If you're reading form a database then perhaps SQLExecutor can be used instead.
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.
@deneb Unfortunately it is not possible to select which attributes you can read in FeatureReader, as you can with the 'native' reader. FeatureReader does not yet expose all the parameters and functionality if each Feature Type. Please add your voice to this Idea, along with any comments on why this is important to your workflow. If you're reading form a database then perhaps SQLExecutor can be used instead.
@deneb Unfortunately it is not possible to select which attributes you can read in FeatureReader, as you can with the 'native' reader. FeatureReader does not yet expose all the parameters and functionality if each Feature Type. Please add your voice to this Idea, along with any comments on why this is important to your workflow. If you're reading form a database then perhaps SQLExecutor can be used instead.
Thanks SQL Executor do what I need, I have add my voice to the https://community.safe.com/s/idea/0874Q000000TkwUQAS/detail .
Learning FME at home after work is a big challenge, Many thanks. Best Regards