+7sql creator load the data always ,but sometimes i do not need this data to load and it takes long time .
Could i write function inside sql creator that it should delay till we see if another specific transformer (tester - passed) has data or not .
if yes so u should work ,if not so do not load ur data .
How couldi achieve that ? Thanks in advance .
FME 2018
+60You are looking for SQLExecutor, apart from having an inputport to initiate it is equal to the SQLCreator. Now you can test for data from a Reader or FeatureReader upstream and initiate it. Use a Sampler if the data upstream has more than one feature to prevent it being triggered multiple times.
+7You are looking for SQLExecutor, apart from having an inputport to initiate it is equal to the SQLCreator. Now you can test for data from a Reader or FeatureReader upstream and initiate it. Use a Sampler if the data upstream has more than one feature to prevent it being triggered multiple times.
thanks ,i think that what i need .
