Skip to main content
Solved

FeatureMerger query

  • February 4, 2015
  • 4 replies
  • 16 views
J
Hello,

 

I have 2 csv first CSV with Id and other csv with ID plus additional attributes. My aim is to get geometry from Oracle Spatial based on IDs from first CSV using featureReader and then use featureMerger to add addinal attributes from 2nd csv (joining on ID). For some reasons I am not able to write to destination writer. I have created a schema file for writer. I am getting an error as "no schema defined for feature .... " for FeatureReader.

 

 

what I am doing wrong here?

 

Cheers

 

John

Best answer by gio

Create a schema wich is a combination of the schema from the columns of the oracle table(s) you read and the additional attributes.

 

Then you should have covered all attributes.

 

 
View original
Did this help you find an answer to your question?
This post is closed to further activity.
It may be a question with a best answer, an implemented idea, or just a post needing no comment.
If you have a follow-up or related question, 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.

4 replies

gio
Contributor
Forum|alt.badge.img+15
  • gioContributor
  • Contributor
  • Best Answer
  • February 4, 2015
Create a schema wich is a combination of the schema from the columns of the oracle table(s) you read and the additional attributes.

 

Then you should have covered all attributes.

 

 
takashi
Influencer
  • takashiInfluencer
  • February 5, 2015
Hi John,

 

 

I don't think the FeatureReader requires a specific schema definition in general.

 

Could you please paste error messages shown on the Log window?

 

 

Takashi
gio
Contributor
Forum|alt.badge.img+15
  • gioContributor
  • Contributor
  • February 5, 2015
I don't think he needs the schema when using a feature reader as well.

 

But if he does use a schema derived form the tables read by the featurereader and then adds extra attributes, then i gather that the extra attributes are not in the schema. Hence the error.

 

 

Thats why i suggested, if using a schema with the writer, to combine the new attributes with the schema from the tables.
takashi
Influencer
  • takashiInfluencer
  • February 5, 2015
I guess he created a look-up table for the dynamic writer feature type, since he said "I have created a schema file for writer". And I'm wondering whether the feature type name defined in the table matches with actual feature type name to be written.

 

Anyway, cannot specify the reason unless seeing the error log.

Helpful Members This Week

Community Stats

31,209
Posts
118,327
Replies
38,811
Members

Latest FME

Terms & ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

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