I have a workspace with 3 feature classes being read from an ESRI SDE 9.3.1 geodatabase (Oracle 11g). There are about 440,000 features total and reading the features takes about 45 minutes while transforming only takes about 10. (I tested this by disconnecting all the readers from their initial transfomers so the workspace would end after the features were read in.) I only need a couple of attributes from each feature class so I was wondering if there is a way to only read in the attributes I need rather than all of them. The SQLCreator or FeatureReader both look promising or maybe even SQL Statement To Execute Before Translation (under Reader --> Parameters --> Advanced). Anybody have advice/expertise to point me in the right direction? It would be most appreciated. (Win7 64-bit, FME 2014, Build 14230, 32-bit).
Thanks,
Aaron
Albuquerque, NM