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 ?
Page 1 / 1
@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