Question

Is there a way to distinguish feature types whether they are real tables or views?

  • 21 December 2016
  • 2 replies
  • 1 view
P
Badge

Hi,

I need to reproject feature coordinates (with ReframeReprojector) coming from an Oracle Spatial Object reader and therefore want to exclude feature types that are views from being reprojected.

Manuel

2 replies

erik_jan
Rank
Userlevel 2
Badge +12

You can use the SQLExecutor transformer to get information from the TAB table in the Oracle database (Select tabtype from TAB where TNAME = '@Value(fme_feature_type)'). This will show if the fetaure type is a VIEW or TABLE.

itay
Rank
Badge +16

Optionally you can just filter out the views if the information can be found in feature type (e.i using V or VW for view in the feature type name) eventually try avoiding reading the views if the naming is consistent by using the Feature Type To Read parameter.

Hope this helps.

Reply


Community Stats

28,631
Posts
109,172
Replies
36,510
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.