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.
Question
How to make sure that the Readers in the nav pane is completed when, the major part of, data is read by SQLexecutor?
+17- Supporter
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)"
+18- Contributor
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!
+18- Contributor
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.
itay wrote:
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)"
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.