I could just sample one feature from the datastream triggering the SQLexecutor. But do you know a nicer way to do this? I need suppliers first in a few featureMergers downstream.
Page 1 / 1
Hi @hsamor,
Use a Creator + SQLExecutor and make sure the Creator is set to yes.
" Create at End determines whether the feature is created after all reader features have been processed (Yes)"
Why not use the SQLCreator instead of the Creator + SQLExecutor combination?
If you add a FeatureHolder after the SQLCreator you force the Reader to go first.
NB: The FeatureHolder stores data in memory, so only use this if the dataset is not too big!
Or maybe even better: Use the reader to trigger a FeatureReader (execute the SQL using the WHERE clause to join to the reader data).
That will even let you skip the FeatureMerger as the FeatureReader can merge both datasets.
And it will allow the database to use the indexes, so performance will most likely improve too.
Hi @hsamor,
Use a Creator + SQLExecutor and make sure the Creator is set to yes.
" Create at End determines whether the feature is created after all reader features have been processed (Yes)"