Skip to main content
  • EN

Dear all,

newbie question regarding the below.

Context: I am downloading a GDB from a drobBox each night. If the schema has not changed I wish to load the tables into SDE, along the way add a field with the download date (timestamper).

Specific question : My idea is to use the Tester to check if the "Unchanged" fme_feature_type_name from the ChangeDetector matches the fme_feature_type_name value from the TimeStamper , if so write to SDE. But it is not working as i imagine it.

Any suggestions for how I can solve this would be most appreciated

thanks in advance

Hi @gaborv73,

Instead to use the Tester transformer, i suggest you to use the transformer FeatureMerger.

And the output outside Merged is your result that you want.

Thanks,

Danilo

Hi @gaborv73, thanks for posting your question!

If your fundamental question concerns comparing the two schemas, I'd check out this Q&A; post where @takashi demonstrates how to compare two schemas. As you've done, you can also use the Schema output port of your FeatureReader instead of a Schema reader. Might be worth a try!

Hope this helps.

Nathan

Hi @gaborv73, thanks for posting your question!

If your fundamental question concerns comparing the two schemas, I'd check out this Q&A; post where @takashi demonstrates how to compare two schemas. As you've done, you can also use the Schema output port of your FeatureReader instead of a Schema reader. Might be worth a try!

Hope this helps.

Nathan

Thanks Nathan, it is that Q&A; post that got me started. What i don't understand is how to action those feature classes that pass as "unchanged" through the change detector. And by action i mean grab from the source gdb and write to the sde.

 

 

Hi @gaborv73,

Instead to use the Tester transformer, i suggest you to use the transformer FeatureMerger.

And the output outside Merged is your result that you want.

Thanks,

Danilo

Thanks Danilo, Do I need to expose fme_feature_type_name for it to be available in the Requestor? (or do i just type it in). Is the GDB the requestor and the Schema the supplier? Currently all results from the supplier are going out the unmatched and the schema is going out the unreferenced..

 

Reply


Community Stats

30,189
Posts
114,582
Replies
37,853
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.