Question

is there a method to let SQL creator works or stop ,relates to another transformer .

  • 14 September 2021
  • 2 replies
  • 1 view

Badge +3

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


2 replies

Userlevel 6
Badge +32

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.

Badge +3

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