Question

Attribute Value Mapper: Writing to an an exiting column that has a new data type:

  • 25 November 2019
  • 1 reply
  • 1 view

Badge +6

Enterpirse geodatabase in oracle. Exisiting column has a datatype of double with values of 1,2,3 etc. I want to use ValueAttributeMapper to

remap these values to sphere, board, cube etc. If I change the datatype in arcmap from Double to VarChar2 does it need to be empty or will the workbench take care of this? The

Writer currently has Drop Table: No and truncate Table: yes


1 reply

Userlevel 2
Badge +16

After updating the table in the database, setting the new data type, you can use the Menu item:

Writers > Update Feature Types

To adjust the feature type to the new table definition.

This is the "best practice" way of doing it.

You could also edit the feature type on the User Attributes tab to reflect the right data type.

But the definition in FME must be made to match the database table.

Hope this helps.

Reply