Skip to main content
  • EN

Hi Everyone,

I am new to FME and trying to understand basics. Please help in clarifying below doubt.

 

I have a FME Non-Spatial oracle data reader which is pointing to table 'ABC'.And I have another table 'XYZ' with same schema .

In my FME workbench "Feature types to read" is set as 'ABC', where as 'Feature types' is set as 'XYZ'

 

I also have Where clause set under 'Advanced', please let me know the difference between "Feature types to read" and 'Feature types' and to which table the where clause points to.

 

Thank you in advance.

@nibeditapadhi09​ Feature Types to Read allows you to select which of the feature types defined on your workbench you want FME to read. By default, FME will try and read all the feature types (tables) that are defined on the workspace canvas. So if you add both your tables ABC & XYZ to workbench you can choose which one to read. This is the easiest solution.

This can be taken one step further by using "Merge Feature Type" This allows you to use a wildcard to select tables that you might read, but then use Feature Types to Read to select which feature type to read in this FME job (also know as a dynamic workflow) . This is useful if you have several different tables you might read, or if the table names change quite a bit

Thank you Mark

Reply


Community Stats

30,179
Posts
114,561
Replies
37,844
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.