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.
@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.
markatsafe wrote:
@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
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.