+51Hello,
I'm looking the better way and automatic to do this.
I have two Databases ( Oracle and Microsoft SQL Server Spatial ) and need to compare the datas between the two tables:
The tables has 80 attributes in common ( with the same name ) and need to merger, i think to use the transformer FeatureMerger.
My question is: Need i to select manually in FeatureMerger the attributes Requestor and Supplier to 80 attributes?
*Example with just 3 attributes add manually
Thanks,
Danilo
Best answer by david_r
Why not use the Matcher? In particular, look at the "Attribute matching strategy" setting.
+6If two table have same attribute names and case,You can select the first 79 attributes in Group By,then set Requestor to Supplier with the last attribute. If the attribute names or case of the two tables are different, you can rename them first.
Why not use the Matcher? In particular, look at the "Attribute matching strategy" setting.
+51If two table have same attribute names and case,You can select the first 79 attributes in Group By,then set Requestor to Supplier with the last attribute. If the attribute names or case of the two tables are different, you can rename them first.
Thanks,
Danilo
+51Why not use the Matcher? In particular, look at the "Attribute matching strategy" setting.
Thanks your help:)
