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
Question
Is there a way to distinguish feature types whether they are real tables or views?
This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
+26- Contributor
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.
+18- Supporter
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.