Skip to main content
  • EN

sql 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

You 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.

You 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 .

Reply


Community Stats

30,176
Posts
114,543
Replies
37,836
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.