I am experiencing difficulty while transforming data from ArcSDE or FGDB
to MITAB. Reading a <Null> or no value from the reader, MITAB writes it as
'-9,999', which is unacceptable in my operations and queries.
My addressing database contains approx. 4.5million records where majority of records contains <null> for various attributes (e.,g., <Null> for numeric attributes and blank/no value for string attributes).
While writing to MITAB, FME converts represent the value as '-9,999'
whereas, I expect the values same as reader (<Null> or blank).
I tried using all parameters in 'NullAttributeMapper', that worked well on 'String' values but not on 'Numeric' values.
I also tried using 'AttributeCreater' to and 'AttributeValueMapper' which didn't proved well.
So need an expert advise on how to manage Null attribute values in MITAB, so I should get rid of the issue caused by '-9,999' values.
Thanks